try
msgbox activeworkbook.sheets.count

--
Don Guillett
SalesAid Software

"Heather Irvin" wrote in message
...
Is there a way to count the number of pages being used in a spreadsheet
and
then show them in a msgbox?

Thanks,
Heather