Hi Richard

This should work for you:

Range("TPS").EntireRow.Hidden = True

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Richard Gavey" wrote in message
...
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