Basic Question - How do I return the worksheet number of the active worksheet?
 

Pretty much says it all in the subject. I know it's fairly basic - I
just need to return the activesheet number so I can plug it into my
marco so when it runs, the settings change depending on which sheet the
user is looking at...

Cheers

Reg

Basic Question - How do I return the worksheet number of the active worksheet?
 

Hi Regnab,

Try:

ActiveSheet.Index

---
Regards,
Norman


"Regnab" wrote in message
oups.com...
Pretty much says it all in the subject. I know it's fairly basic - I
just need to return the activesheet number so I can plug it into my
marco so when it runs, the settings change depending on which sheet the
user is looking at...

Cheers

Reg

Basic Question - How do I return the worksheet number of the active worksheet?
 

That's it - perfect. Thankyou Norman....