Return the number of Sheets in a Workbook

[gminor7]

Is there a way in VB to return the number of sheets in a workbook

 

[Jos Vens]

Yes there is:

ActiveWorkbook.Sheets.Count

Regards,
Jos Vens

 

[gminor7]

Thanks

 

[Bob Phillips]

activeworkbook.worksheets.Count

counts just the worksheets as opposed to all sheets, and

activeworkbook.charts.Count

counts the number of charts

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Yes there is:

ActiveWorkbook.Sheets.Count

Regards,
Jos Vens