My Account
Sign up, and you'll be able to vote in polls.
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Aug 20, 2014
12:28
:23
pm
Talker
Solution for any interested
Dim totalNumSheets As Integer
totalNumSheets = Application.Worksheets.Count
For sheetNumber = 5 To totalNumSheets
Sheets(sheetNumber).Select
Range("C4").Select
Next
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 18, 2024
Total posts
3,311 (188 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