Hide Row Macro

[QUOTE=Richard Buttrey;4817545]

Originally Posted by Joe.RBI

This is the code that I have come up with but it won't run. Doesn't give any errors, just doesn't run.


Why are you not following the example I gave and ignoring the advice? There is no need to name the sheet since you are using a sheet change event. The sheet name is irrelevant.

You are also hard coding a cell reference. That's not good practice. You were advised to use a range name.

I'm not sure I am following you. At no point did I ignore any advice, I tried your code and only changed the range value to the desired cell name. What do you mean by "hard coding a cell reference"? I have a named cell that has a list with three options that reference a separate tab.