New here. I'm attempting to condense the commented out code with the nested for loops above. Can't get vba to recognize the "i" counter in worksheet sheet name. For example, I have it as "Section i" and on the first loop I want it to read "Section 2" in order to make macro hide the sheet labeled "Sheet 2". Any help or direction would be great, thanks
-
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.
Using For loop counter in Sheet name
- Thread starter PioSwgr
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,795
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
Anything between the double-quotes is treated as literal text. So variables need to be outside of the double-quotes, i.e.
Anything between the double-quotes is treated as literal text. So variables need to be outside of the double-quotes, i.e.
VBA Code:
Worksheets("Section " & i)
Upvote
1
Solution
Similar threads
- Question
