Hi Paul

I use a function that find the last used row in the sheet already
See the code

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


"Paul Lautman" wrote in message ...
Try coupling Ron's code with the lastcell() function at
http://www.beyondtechnology.com/geeks012.shtml

to reliably obtain the last used row on the page.

"Ron de Bruin" wrote in message
...
Hi Jayhawktc

Try this
http://www.rondebruin.nl/copy2.htm


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


"Jayhawktc " wrote in message
...
I am in need a macro that will take data of varying length and copy it
to a master worksheet. The information needs to be copied and then
pasted below the previous one on the master sheet so that I can compile
all the information on one sheet. The data on each sheet is always the
same amount of columns but the number of rows will vary. Any help with
this is greatly appreciated.

Thanks,


---
Message posted from http://www.ExcelForum.com/