Find last relevant row in range and set as print area

[Grilleman]

What I need is a macro that identifies and selects, as my print area, all rows in column B that contain a value plus all rows in colun A up to and including the next instance of the value "Y".

In my attached sample workbook the last row containing data in column B is row 11. So I need to include all rows through row 11 in my print area. In addition, I need to include in my print area rows 12 and 13 since the next instance of the value "Y" in column A is two rows below the last row containing data in column B.

I need a macro as this solution will be part of a larger app I'm working on. Any help is very much appreciated.

Thanks!

[MarvinP]

Hi Grilleman,

Here is code to go to the last cell in column B and then search for the next cell that has "Y" in it. See if this helps your question: Run the "LastRowInB sub to see answer.

Please Login or Register  to view this content.

find relevant last row sample for Grilleman.xlsm

[Mumps1]

Try:

Please Login or Register  to view this content.

[jolivanes]

And

Please Login or Register  to view this content.