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