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!