See this example
http://www.rondebruin.nl/copy1.htm

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



"rglasunow" wrote in message
...

I'm currently trying to write a macro that will bring the data to the
last row. Simular to when you 2x click on the bottom right hand of a
cell and it brings it to the last row. My problem is the macro records
the last row and when add additional rows to the spreadsheet it still
brings it to the original row recorded in the macro. Is there any code
that will allow the data to copy to the last row regardless of amount of
rows?

Thank you,
Ryan


--
rglasunow
------------------------------------------------------------------------
rglasunow's Profile: http://www.excelforum.com/member.php...fo&userid=4212
View this thread: http://www.excelforum.com/showthread...hreadid=548713