adamstarr12
New Member
- Joined
- Jun 11, 2013
- Messages
- 8
Hello Everyone,
I'm fairly inexperienced with vba, and realize things can be done/approached many different ways. I'm guessing I have made an incorrect starting approach.
I have one workbook that has about 100 tabs on it that I regularly use, and I just hide the tabs that I am not using. I would like each one of these tabs that I do NOT hide to have an "exhibit #" (or pg #) in cell A1 that I can automatically update after hiding some sheets and leaving others, by running a macro.
Here is what I have tried, and it works, but does not skip hidden pages :
For i = 0 To [v]
c = + 1
If < [v] Then Worksheets(c).Activate Else Exit For
[A1].Select
Selection.ClearContents
ActiveCell.FormulaR1C1 = "Exhibit " &
Next i
v- #visible pages
I'm wondering if anyone could recommend some instructions or modify this to perform.
Thank you very much!
A.S.
I'm fairly inexperienced with vba, and realize things can be done/approached many different ways. I'm guessing I have made an incorrect starting approach.
I have one workbook that has about 100 tabs on it that I regularly use, and I just hide the tabs that I am not using. I would like each one of these tabs that I do NOT hide to have an "exhibit #" (or pg #) in cell A1 that I can automatically update after hiding some sheets and leaving others, by running a macro.
Here is what I have tried, and it works, but does not skip hidden pages :
For i = 0 To [v]
c = + 1
If < [v] Then Worksheets(c).Activate Else Exit For
[A1].Select
Selection.ClearContents
ActiveCell.FormulaR1C1 = "Exhibit " &
Next i
v- #visible pages
I'm wondering if anyone could recommend some instructions or modify this to perform.
Thank you very much!
A.S.
Last edited:
