VB code to select all rows with data in a column

[HelenW]

Hi lovely Excel people

I hope someone can help with this. In my macro, I need code that will select all the rows that contain data in a given column, minus the first row which has a header.

Hope you can help!

Helen

[Krishnakumar]

Hi,

Please Login or Register  to view this content.

HTH

[Leith Ross]

Hello Helen,

When you say all rows that contain data, does that mean there could be blank rows mixed in with the non-blank rows also?

Sincerely,
Leith Ross

[HelenW]

Hi Leith - no, there will be no blanks, but I only want to select as far down as the data goes. There will be a different number of rows each time I run the macro.

Krish's code is great, but I took off the bit about the message box (not needed as the macro will then carry on and do other stuff) and it didn't show as selecting anything!

Thanks for your help.

[HelenW]

Just wanted to bump this one back up in case anyone can help!

[Krishnakumar]

Hi,

What do you want after getting the range?

[HelenW]

It's ok - will mark as solved as I figured out what I wanted to do. Thanks!