Hiddening Rows in an embedded worksheet
 

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

Hiddening Rows in an embedded worksheet
 

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

Hiddening Rows in an embedded worksheet
 

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

Hiddening Rows in an embedded worksheet
 

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

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



Wendy wrote:

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

--

Dave Peterson

Hiddening Rows in an embedded worksheet
 

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