Selecting All Used Rows Including and Underneath Specific Value

Hello World!

I have been working on an excel worksheet that is generated by one of our project reporting systems. The system exports to excel all of the financial information for the project being reviewed.

Every generated worksheet has the word Programme somewhere in Column B, however, given each project produces a worksheet with varying rows, Programme can appear anywhere from B6:B999.

I would like to select all rows beneath and including the word Programme.

Please Login or Register  to view this content.

The above code searchs for Programme and then selects the row and then moves the selection one row beneath.

I need the code to search for Programme, select that row, and then include all rows below in the selection.

Inspiration?

Hi
try this macro
note it is case sensitive and will find "Programme" but not programme" - let me know if this is a problem

Please Login or Register  to view this content.

Thank you Nicky and Winon.

Unfortunately, I could not get either of your codes to actually cooperate with my sheet. After bashing my head against the keyboard, I have decided to just rig it to work. As the number of rows will vary greatly per sheet, I have defined two variables as my range. The first being the activecell.row where Programme has been found and the second an arbitray number that I believe will encompass the entire range of cells that I am trying to select.

Please let me know if there is anything you see that can be approved upon.

Please Login or Register  to view this content.

Thank you again.