I am some what new to the world of Macros and I need to know if there is a Macro that I can use in VBA for excel 2010 that will show only 10 columns at a time. As 1 column is added 1 hides. I have a chart attached to the columns and need it to hide the info of the hidden columns. Columns A:C must be shown at all times and columns "D:BI" need to hide if value of cells "D23":"BI23"=0 and if cells "D91":"BI91"=0 but if column "O" is shown I need "D" and all its values hidden and so forth columns are attached to sheets and update as sheets are filled out.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
show and hide only 10 columns
- Thread starter chrisroe
- Start date
