| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Hide columns
Good afternoon,
I am trying to create a macro to hide certain columns on a spreadsheet, how best do i do this, say want to hide columns g, h, u, ac & ae |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to Hide columns
The best way is to record the macro. Turn on the macro recorder, hide your
columns, then stop the recorder. You can then look at the code by pressing alt+F11. Regards, Fred. "whatzzup" wrote in message ... Good afternoon, I am trying to create a macro to hide certain columns on a spreadsheet, how best do i do this, say want to hide columns g, h, u, ac & ae |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to Hide columns
Sub Macro()
Range("G1,H1,U1,AC1,AE1").EntireColumn.Hidden = True 'OR 'Range("G:G,H:H,U:U,AC:AC,AE:AE").Columns.Hidden = True End Sub If this post helps click Yes --------------- Jacob Skaria "whatzzup" wrote: Good afternoon, I am trying to create a macro to hide certain columns on a spreadsheet, how best do i do this, say want to hide columns g, h, u, ac & ae |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to Hide columns
Hi,
Range("G:H, U:U, AC:AC, AE:AE").EntireColumn.Hidden = True Mike "whatzzup" wrote: Good afternoon, I am trying to create a macro to hide certain columns on a spreadsheet, how best do i do this, say want to hide columns g, h, u, ac & ae |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Hide-Unhide Columns with a macro | Excel Discussion (Misc queries) | |||
| Macro to hide the row if both columns E & F are blank in that row. | Excel Worksheet Functions | |||
| Need a macro to hide certain columns | Excel Discussion (Misc queries) | |||
| macro to hide columns | Excel Worksheet Functions | |||
| how can hide and show columns using macro? | Excel Worksheet Functions | |||
Linear Mode
