macro_panic
New Member
- Joined
- Mar 17, 2002
- Messages
- 47
is there a macro genius out there who knows how to automate hiding columns in excel, please? i have a large-ish spreadsheet with many columns which may or may not be used depending on user input, and i want to hide the unused columns so they don't print / take up screen space. is it possible to hide columns dependent on the contents of cells i.e. "if cell H3 on sheet 1 is blank, hide columns F, H, and K on sheet 2"
thanks in advance
thanks in advance