| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Programming | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
Linear Mode
