Return the number of Sheets in a Workbook

  • Thread starter Thread starter gminor7
  • Start date Start date
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)

Jos Vens said:
Yes there is:

ActiveWorkbook.Sheets.Count

Regards,
Jos Vens
 
Back
Top