or if there are chartsheets as well

Activeworkbook.Sheets.count

--
regards,
Tom Ogilvy


"Michael" wrote:

NumberofSheets = ThisWorkbook.Worksheets.Count
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"tc" wrote:

Hi. I want to create a macro that will count the number of sheets in a
particular workbook. Is this possible?