Clear All from last row of data down
 

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

Clear All from last row of data down
 

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.



---
Regards.
Norman


"JohnUK" wrote in message
...
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