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

Thank you,
Rya

--
rglasuno
-----------------------------------------------------------------------
rglasunow's Profile: http://www.excelforum.com/member.php...nfo&userid=421
View this thread: http://www.excelforum.com/showthread.php?threadid=54871

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