For reasons I need to export only certain columns from a sheet and save that down as a .CSV file. This needs to be done via a macro button. Yes indeed.
Obvious would be to open a new workbook, copy the relevant columns into it and then save as CSV. Should be straightforward but there's always that extra bit of effort trying to fix it for some annoying edge case that you hadn't anticipated.
For reasons I need to export only certain columns from a sheet and save that down as a .CSV file. This needs to be done via a macro button. Yes indeed.
Is this possible?