Formula or code to hide or unhide rows based on value in a cell

I need to hide rows in my worksheet. Is there a way to do the following:

If the value in a cell is "Hide" can I hide the remaining rows in the worksheet until row 408 is hidden. Example - If the first "Hide" i encounter in column "U" row 175 then I want to hide rows 175 thru 408 regardless of the values in $U176:$U408.

I've attached a sample workbook - the worksheet is named CA_RR1_D

Thanks for any help you can offer

Hi there,

Here's a "manual" way of doing it

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi TMS,

Thank you for that code, I am a 100% novice with VBA code - Could you let me know what column the code is set to check - I don't know enough about the VBA to see that. Once I put the code in will it execute whenever a cell in column U changes?

Hi Greg,

I have put your code in but nothing happens - do I need to do anything to activate the code? I'm have virtually no experience with VBA.

Thanks for your help

Hi again,

Open the attached workbook and click on the button located in Cell U1 - that should do it

Hope this helps - please let me know how you get on.

Regards,

Greg M

Greg,

Thanks for that coding - It works great!!! I will mark this thread resolved

ok, thanks - I appreciate your time. The coding from Greg M and you both worked like I wanted!!! Thanks so much. I am marking this thread resolved.

Hi again,

Many thanks for your feedback and also for the Reputation increase

Very pleased that I was able to help.

Best regards,

Greg M

Hi Greg,

I used your code and it did exactly what I asked but after further review of the results I would like to make a change. Can I examine in reverse and check last row to first and then exit when I find "UNHIDE" in column U. The reason is the way I set it up originally I wind up with several header rows at the end which I don't want to print. I've changed my formula to mark all header rows (First row after each page break) with value of "HIDE". I tried reversing the "For " statement to be LAST_ROW To FIRST_ROW but that doesn't do anything. I reverted this thread to unresolved - but let me know if I need to mark it back to resolved and start a new thread.

Thanks again for your help.

OOPS - I found out on Google how to do what I need by adding "step -1" to the for loop. I'll re-mark as solved. Hope I didn't waste your time

Thanks much!!