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