My Account
Sign up, and you'll be able to customize your font size and more!
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Aug 20, 2014
12:31
:31
pm
Talker
Definitely.
Seeing what some people come up with is funny to me. But, hey, if it works, right?
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
Talker
Bio page
Talker
Joined
Aug 30, 2007
Last login
Apr 30, 2024
Total posts
3,313 (189 FO)
Report problem with this ad
Messages
Author
Time
VBA Question
Talker
8/20/14 12:18pm
If your sheets are all called "Sheet5", "Sheet6", "Sheet7", etc
Indy Coug
8/20/14 12:20pm
Unfortunately they're not, they're names...
Talker
8/20/14 12:24pm
just cycle through the sheets by index, not by name
BYUCoug11
8/20/14 12:21pm
Perfect. Thanks!
Talker
8/20/14 12:25pm
just reread your post - are you asking how to get the # of sheets in the book?
BYUCoug11
8/20/14 12:27pm
Alternatively...
Indy Coug
8/20/14 12:27pm
Worksheets count is what I used, but your post directed me to a good google sear
Talker
8/20/14 12:28pm
Solution for any interested
Talker
8/20/14 12:28pm
The beauty of Excel is there are multiple solutions possible
Indy Coug
8/20/14 12:30pm
Definitely.
Talker
8/20/14 12:31pm
A thing to note here is that Application.Worksheets refers to the ActiveWorkbook
JadoX
8/20/14 1:00pm
Definitely, thanks.
Talker
8/20/14 1:11pm
Report problem with this ad
Posting on CougarBoard
In order to post, you will need to either
sign up
or
log in
.
Report problem with this ad