Previous Topic Next Topic

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

Answer 1 / 2
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
Jason
Jun 14, 2010 at 06:00 PM
Perfect! Thanks!
0
Answer 2 / 2
Usama
Aug 22, 2013 at 11:34 AM
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses