Set No of Sheets in new workbook

  • Thread starter Thread starter cornishbloke
  • Start date Start date
C

cornishbloke

Hopefully a quickie for someone ;)

When using the VBA code:

workbooks.add

how do I determine the number of sheets in that newly created workboo
(i.e rather than using the value set in excel's options on eac
individual pc)
 
Workbooks.Add
cSheets = ActiveWorkbook.Worksheets.Count

--

HTH

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