Macro to automatically select a range

Dear all,

please have a look at the attached file. I would like a macro to autmatically select a specific range, starting with the active.cell ( which is always in Column B ) and then up until no entry is found in Column I. I have included a screenshot that shows the selection.

Any help, thank you muchly !

Felix

EDIT: in this case, starting cell was B24, range is therefore B7:P24
EDIT2: vertical range is always from Column B to Column P.

In your spreadsheet there is no data beyond row 24. Is it possible that there could be more data contained in Rows 25 and beyond and that column I is not blank? Or will once you find column I blank, the rest of the column will always be blank. If that is the case, could you have more than one range you are looking to select. Also, once selected, what action will occur?

and yes, once it finds Col I blank, there will be no data beyond that in Col I

EDIT: The row with the starting cell will also be the last row of the selection, no matter if there is data beyon that or not ...

I think you are looking for this

Please Login or Register  to view this content.

This worked for me:

Please Login or Register  to view this content.

Or something like this, given the current structure of the sheet, where the range depend on your activecell in column B:

Please Login or Register  to view this content.