Wendy

Formulas cannot hide anything, only return values.

You must have some VBA code that hides the columns.

Don is suggesting you turn on the macro recorder, slect A1:A30 and FormatHide
to see what code you get.


Gord Dibben MS Excel MVP

On Thu, 31 May 2007 13:30:03 -0700, Wendy
wrote:

Hi Don,
I am very green in this area and don't understand your response. Could you
explain further what type of formuala I would use?

"Don Guillett" wrote:

Easy to tell you but better if you record the macro while doing to see the
diff..

--
Don Guillett
SalesAid Software

"Wendy" wrote in message
...
I am using this formuala to hide columns: Columns("by:cc").Hidden = Not
Columns("by:cc").Hidden

What formula do I use to hide a row?
I am trying to do it for rows A3:A30, and get a syntax error.
thanks