Hiddening Rows in an embedded worksheet

[Guest]

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

 

[Don Guillett]

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

 

[Guest]

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?

 

[Dave Peterson]

try using
Rows("3:30").hidden = ......

(I'm not giving too much away <vbg>.)

 

[Gord Dibben]

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 Format>Hide
to see what code you get.


Gord Dibben MS Excel MVP