Select Column to Last Used Cell

[EnigmaMatter]

Hello,

I want to select a column of data using VBA, but I cannot use Macro Recorder and CTRL+SHIFT+DOWN because some of the cells are blank and it only selects partial data in the column stops at the first blank and doesn't select the data below it.

Essentially, how do I select an column to the last cell that contains data?

[YasserKhalil]

Try this

Please Login or Register  to view this content.

Or this

Please Login or Register  to view this content.

To select the range from A1 to the last cell which has data in.

[EnigmaMatter]

...I knew this, I swear. I must have been having a brain lapse there.

Thank you so much.

[YasserKhalil]

you're welcome Mr. EnigmaMatter
All of us sometimes have this brain lapse..!!
Regards