Thank you both for your replies.
Please see below for my individual replies to your feedback.
Anyways, what I did:
I did my copy and paste twice:
Once using the PasteSpecial=Values to get the correct info, and export only the data I wanted.
Then a second Copy, this time of only the last...
Hi
First post, so here goes:
I have a spreadsheet with 20 columns, and need to copy these rows of data (ie without the header rows) into a new sheet, and then save as a csv file.
Several columns have formulas, and the last 3 columns often will not contain any data in them at all...