Show/Hide Rows Columns based on value in named range

Hi,

I have written the following code to try and hide a certain column depending on the value in a named range (single cell).
It does not seem to hide the column unless I have the named range on the same worksheet and I don't want it to be there, I want it to be on a separate worksheet. I am very new to VBA so this is maybe an impossibility or that I have made some silly rookie error; perhaps you could enlighten me as to which is true?

Please Login or Register  to view this content.

Just add a sheet criteria before specifying the columns like this..

Please Login or Register  to view this content.

Replace SheetName by the name of target sheet (keep the double inverted commas)

Hope that works!!