Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Unhide & Hide Columns with VBA
Hi,
In fact I would like that VBA insert some columns (with the same Formating as one specific column. But i don't know how to do that & I was thinking to create all the columns I need Hide them before I start the program & later the program unhide the columns it needs. Any Idea how to do that? Thant you very much. jean |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Unhide & Hide Columns with VBA
You could record a macro when you hide and unhide a column to see the code you
need. And you could record a macro that would insert a new column, then copy an existing column and paste special|Format over that new column. jean wrote: Hi, In fact I would like that VBA insert some columns (with the same Formating as one specific column. But i don't know how to do that & I was thinking to create all the columns I need Hide them before I start the program & later the program unhide the columns it needs. Any Idea how to do that? Thant you very much. jean -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide / Unhide columns for Printing | Excel Discussion (Misc queries) | |||
Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
Auto hide/Unhide columns | Excel Worksheet Functions | |||
Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
Unhide and hide columns | Excel Worksheet Functions |