Macro to Hide/Unhide rows based on the result of a formula

**TMS** · 01-20-2015, 10:42 AM

That code WILL actually work because it fires on ANY change.

So, if for example, M39 has

Formula:

=A1

and you enter "N" in cell A1, the event handler will fire and find the value "N" in cell M39.

You probably DON'T want it to fire every change though.

Regards, TMS

**c850b** · 01-20-2015, 11:17 AM

I've been playing with this and realize what my issue is, the Y/N is picked from a pull down on another worksheet "DATA_INPUT" and looks like this

Formula:

=Data_Input!B18

The worksheet "QUOTE" which I have the macro assigned to is a completely generated sheet with no input on it, it is simply a results page. I guess my question now is what do I need to change in order to allow this macro to work with a result from another worksheet?