Macro that will select range based off cell value in multiple rows

I have a worker book that has data ranging from D4:AM103

I'd like to be able to create a Macro that will look at column I4:I103 If any of these cells have data (last name) then it will select that entire row (from D:AM) Nothing more than SELECT is needed.

The data is normally sorted first, so the rows that have data in them will likely be continuous...

Sample attached. In this sample the macro would select range D4:AM15 as cells 4:15 have data in column I

Thanks.

Rob

2014 CPS ONTARIO Sealing STATS.xlsx

Thanks Proton - Won't that only highlight the rows though? I want to be able to select the rows (quickly) so that I can then copy/paste into another document..

Hi Rob,
try

Please Login or Register  to view this content.

That seems to work great Nilem, thanks! What if I wanted to copy the selection also? I just realized that would make even more sense...

Thanks again..

Rob

Please Login or Register  to view this content.

haha... You can see I'm not a pro at this!

Thanks for all your help... I'll double check and play with it for a day and then mark as solved..

Rob

Hi Nilam - Works great Thanks. Marking as solved. Quick question. How would I change the macro to look at another column instead of I?

Please Login or Register  to view this content.

6th column relative to the range D:AM, ie column I
3d column is the column F
10th is the column M, etc.

Perfect.

Thanks again.