Excel Macro help, hiding columns

Solved/Closed
Jason - Jun 14, 2010 at 04:30 PM
 Usama - Aug 22, 2013 at 11:34 AM
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
Related:

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 14, 2010 at 05:35 PM
Rows A-K or columns ?

If that is the case then



For Each Sheet in Sheets
Sheet.Columns("A:K").Hidden = True
Next
0
Perfect! Thanks!
0
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?
0