The beauty of Excel is there are multiple solutions possible

Report problem with this ad

Aug 20, 2014
12:30:32pm

Indy Coug

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.

Posting on CougarBoard