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:27
:44
pm
BYUCoug11
just reread your post - are you asking how to get the # of sheets in the book?
if so, just use Worksheets.Count
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
BYUCoug11
Previous username
SFBayCoug
New username
Mike Honcho
Bio page
BYUCoug11
Joined
Feb 27, 2011
Last login
Jan 3, 2017
Total posts
0 (0 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