Hide/Unhide rows based on Cell Value

[noelwri]

Hi,

I need some assistance is writing a macro (I think?) to hide rows based on cell(s) value.


I have 4 columns:

"Number"
"Name"
"Last Year $"
"This Year $"


If "Last Year $" and "This Year $" = $0, I want to be able to automatically hide the row. I am working with a spreadsheet that has over 200 rows of data.


I am also interested to know of a way to automatically unhide a row if the statement above is no longer true.


I do not have alot of experience with macros so any basic help is greatly appreciated. Thanks.

[thameem127]

Below link may help you.

http://www.excelforum.com/excel-gene...ll-result.html

[noelwri]

Thanks for posting that link. I had actually viewed that post earlier and couldn't figure out to make that example work for me. My scenario has two variables in that two cells must equal $0, then I want it to hide the row.

If you can help with changing the macro, I would be most appreciative. Thanks.