| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidding Columns with R1C1
Gentlefolk,
Can I use R1C1 or CELLS() to hide columns by NUMBER rather than by letter? Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hidding Columns with R1C1
with activesheet
.cells(3,6).entirecolumn.hidden = true 'or .columns(6).hidden = true end with Greg Glynn wrote: Gentlefolk, Can I use R1C1 or CELLS() to hide columns by NUMBER rather than by letter? Greg -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hidding Columns with R1C1
Thanks Dave ... Perfect.
Greg Dave Peterson wrote: with activesheet .cells(3,6).entirecolumn.hidden = true 'or .columns(6).hidden = true end with Greg Glynn wrote: Gentlefolk, Can I use R1C1 or CELLS() to hide columns by NUMBER rather than by letter? Greg -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Discussion (Misc queries) | |||
| help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Worksheet Functions | |||
| Excel - columns described R1C1, R1C2 | Excel Discussion (Misc queries) | |||
| Hidding columns not working | Excel Programming | |||
| Hidding columns | Excel Programming | |||
Linear Mode
