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 |
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 |
All times are GMT +1. The time now is 10:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com