Hi,
Every time I copy and paste values from one workbook to another, I end up
overinflating the size of the second file considerably. The data from the
first workbook is filtered, and when I copy, I copy the columns. For some
reason, it picks up something from the blanks in the first workbook and
copies into the second, even though I paste values?? (I have even tried Clear
All from the blanks of the first file)
I just need a piece of code that finds the last row of data, and ‘clears
all’ below that row.
Many thanks for help
Regards
John