Hiding rows that are included in a named range
 

I'd like to programmatically hide all the rows that are included in my named
range of TEST. How would I do that. TEST only has one column of data and
multiple rows and is continuous.

Hiding rows that are included in a named range
 

Range("TEST").Rows.Hidden = True

conversely, to unhide

Range("TEST").Rows.Hidden = False


--
Cheers
Nigel



"Barb Reinhardt" wrote in message
...
I'd like to programmatically hide all the rows that are included in my
named
range of TEST. How would I do that. TEST only has one column of data
and
multiple rows and is continuous.