Hi Eric

I like to use the lastrow function

I use it here
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Eric Anderson" <Eric wrote in message
...
I am writing a macro that will cut and paste data from different tabs and
aggregate it onto a new sheet. I would like to know the best way to search
the new sheet to find the next blank cell via a macro after data has been
pasted so I can have the macro cut and paste the next portion of data
automatically. Hopefully this makes sense. Thanks, Eric.