Counting Worksheets inbetween two sheets?

[mgao77]

Its it possible to count the number of worksheets in between specific sheets?

For example, I have a "start" sheet and "end" sheet and need to count the number of worksheets in between. Is there a macro that does this?

Thanks!

 

[Andrew Poulsom]

Does this work for you?

Dim ShCount as long
ShCount = Worksheets("end").Index - Worksheets("start").Index - 1

 

[mgao77]

Thanks for your help Andrew. But I do apologize as im a new to VBA.

I've input the macro, but saw no result when i ran it. is it possible to see my result on another sheet? say: "check A10"

Thanks!

 

[Andrew Poulsom]

Try:

Worksheets("check").Range("A10").Value = Worksheets("end").Index - Worksheets("start").Index - 1

 

[mgao77]

Works perfect! Thank you so much..