Clear All from last row of data down

[JohnUK]

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

 

[Norman Jones]

Hi John,

See Debra Dalglish's page on resetting
the used range:

http://www.contextures.com/xlfaqApp.html#Unused

See particularly the section entitled:

To programatically reset the used range

and try the DeleteUnused procedure.