Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide column based on header name
I'm looking for a macro that checks the title of columns and hides
particular ones. For example, using the bwlo sample sheet, a macro that would hide the Age and Location columns automatically: Name Age Sex Location John 1 M Home Steve 4 F Work As a further capability, I was thinking of creating a spreadsheet with a listing of all of the columns that I would like hidden, and then reference that in the macro. So, if the header equals a value on the column hiding list, the macro would hide that column in my actual spreadsheet. Any thoughts? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Hide rows based on value of column F | Excel Discussion (Misc queries) | |||
Macro to rearrange/add columns based on column header? | Excel Programming | |||
Hide column depending on its header | Excel Programming | |||
hide columns based on header macro | Excel Programming | |||
macro to hide column based on header | Excel Programming |