| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert column and hide columns
Thanks Patrick.
"Patrick Molloy" wrote in message ... Range("C:C,F:H,J:J,P:T").EntireColumn.Hidden = True "Rob" wrote: Francois, thanks however the columns aren't concurrent, eg I want to hide c, e, m, j, x Regards, Rob "Francois via OfficeKB.com" <u18959@uwe wrote in message news:80fc6b5184ea6@uwe... Rob wrote: I need to hide a number of columns in a sheet and have used Columns ("C:C").EntireColumn.Hidden = True. This is fine but I have 15 columns to hide and having 15 rows of code seems excessive. Is there a way to declare the columns and thus apply in less rows of code? Also, have similar issue with inserting where to say I want to insert 3 rows, I have 3 rows of code. Thanks, Rob Or:- ("C:Z").EntireColumn.Hidden = True. -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Rows or Columns with +/- button above row/column label headin | Excel Worksheet Functions | |||
| I forgot to insert columns within a column | Excel Discussion (Misc queries) | |||
| hide columns by column number | Excel Programming | |||
| Insert a blank Column Every 9 Columns | Excel Programming | |||
| Insert Blank Column every 9 Columns | Excel Programming | |||
Threaded Mode
