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

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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