You cannot delete those rows, if you do so, Excel just fills it up with new
rows. A worksheet has 65536 rows, period. But empty rows do not use space
when the workbook is saved.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dan Winterton" <Dan wrote in message
...
I am dealing with large blocks of data, ranging from 10,000 to 20,000
rows.

Is there a simple way I can use code to delete all rows below my data,
down
to the very bottom of the spreadsheet? The # of rows will not be the same
each time.

Any help is greatly appreciated.