I am developing an application with a large number of named ranges.
Dependant upon a given scenario, I want to be able to hide the ranges
irrelevant to the particular case.
I have previously achieved this in similar applications by simply specifying
the rows.
i.e. Rows("27:30").Hidden = True/False.

However in this instance I need to be able to regularly add rows to the
ranges in regular use, and I don't want to have to go and edit all my macros
every time I add an item.

The following doesn't work: Range("TPS").Hidden = True

Does anyone know the syntax needed to hide/show a range which is specified
by name?

Regards
R. Gavey