Selecting All Cells Even If Non Contiguous

[53fordtruck]

I get a daily company .csv report that has 10 columns but varying numbers of rows (anywhere from 1200-1500). There are many rows and cells that are blank. I would like to select from cell A3 to the end, including the blank cells, and then alphabetize the data based on column A. I can not figure out how to get all the data selected in VBA. I've tried getting xltoRight and xlDown to work, but keep getting stopped at the first blank row or column. Can someone please point me in the right direction? Thanks.

Sample in image.

Jerry

 

[53fordtruck]

I went through all 3 options and all three worked, as I indicated.

I am new to this site. I found this in the Bill Jelen and Tracy Syrstad book "MS Excel VBA adn Macros".

Thanks to everyone who posted code for me to learn with.

I hope to get from 1 1/2 hours per report to less than 15 minutes. This one issue had me stuck for weeks.

It's great learning something new as a 58 year old. An old dog can learn new tricks.

Jerry

 

[Peter_SSs]

It's great learning something new as a 58 year old. An old dog can learn new tricks.

You are just a pup Jerry.
Stick around, there is plenty to learn. I have quite a few years on you and I am still learning stuff in this forum regularly.