Unfortunately they're not, they're names...

Sign up, and you'll be able to customize your font size and more! Sign up

Report problem with this ad

Aug 20, 2014
12:24:29pm

Talker

Unfortunately they're not, they're names...

Report problem with this ad

Talker

Bio page: Talker
Joined: Aug 30, 2007
Last login: Apr 17, 2024
Total posts: 3,310 (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