Can someone please enlighten with a solution to this:

When I'm writing a macro in VBA and for instance I need to copy a set
of data from one place to another. - however, each time it will be run,
the number of rows of the data that is different - How can I select
just that data ??

Hope that makes sense!


--
CPhil
------------------------------------------------------------------------
CPhil's Profile: http://www.excelforum.com/member.php...o&userid=29842
View this thread: http://www.excelforum.com/showthread...hreadid=495471