My Account
Sign up, and you can customize which countdowns you see.
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Aug 20, 2014
12:20
:18
pm
Indy Coug
If your sheets are all called "Sheet5", "Sheet6", "Sheet7", etc
Then you could say
For sheetNumber = 5 To 28
Sheets("Sheet"&sheetNumber).Select
Range("C4").Select
Next
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
Indy Coug
Bio page
Indy Coug
Joined
Dec 20, 2001
Last login
May 1, 2024
Total posts
184,786 (9,837 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