How do you select the range next to your selected range?

I have 1 column with labels and no empty cells. The column next to it has numbers, but there are empty cells throughout the column. This pattern continues for a few times with an empty column between the numbers from 1 group and the labels for the next.

I have the following code to copy and paste the data from 1 sheet into another.

Please Login or Register  to view this content.

The problem is I can only copy the labels column. The ".end(xlDown)" doesn't work because of the empty rows. If I select the labels column and then hold down shift and push the right arrow it selects the numbers column. How can I do this very simple thing in VBA?

Try coming from the bottom up rather than the top down. Also using resize will help:

Please Login or Register  to view this content.