Hiding Ranges
 

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

Hiding Ranges
 

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

Hiding Ranges
 

Try this

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

Regards
Sid DeLuc


----- Richard Gavey wrote: ----

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 range
irrelevant to the particular case
I have previously achieved this in similar applications by simply specifyin
the rows
i.e. Rows("27:30").Hidden = True/False

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

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

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

Regard
R. Gave

Hiding Ranges
 

Thanks very much for help