Excel Macro help, hiding columns [Solved/Closed]

Report
-
 Usama -
So I'm trying to figure out an Excel macro that would hide row A-K on every worksheet in a workbook.

Thanks for any help

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
Rows A-K or columns ?

If that is the case then



For Each Sheet in Sheets
Sheet.Columns("A:K").Hidden = True
Next
Perfect! Thanks!
Hi Im Trying to find a way via Macro to hide columns based on the value.. example if Cell A1 = Year 4. Hide All Future Columns (Year 5 - Year10).

Can you help me in that?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!