Are the rows really blank ? and are they between the data or below the data

You can use AutoFilter in the code and filter for non blanks and copy to the other sheet

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Nick" wrote in message ...
My problem is that I am using a macro to copy data from one workbook and to
paste into the next, however along with the data I need come about 30,000
blank rows, making the file large.

I could use Go Toblanks and Delete the 30,000 once pasted but that takes
alot of time to sit through.

Idealy I could use Go To(Insert something that selects only non-empty cells)

And then copy/paste that into the new workbook.