Hi Glen,

Try:

Activesheet.Index

---
Regards,
Norman



"Glen" wrote in message
...
I can capture the sheet name with "ActiveSheet.Name"
How do I capture the active sheet number?

Thanks
Glen