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