Why not sort the data to remove the blank lines.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


" wrote:

Thank you very much. This is what I needed to do in the first place.

The other problem I have is that in order to copy the entire ranges
without leaving any data behind, I created (defined) ranges from A2 to
A65536, and B2 to A65536 and so on.

Once I export my data to Excel, and run the macro, is there a way to
only select the cells that have data in them? or do I have to do this
to prevent leaving something behind?