Another option...

You can add a workbook with just one sheet and add as many as you want later.

dim newWkbk as workbook
dim iCtr as long
set newwkbk = workbooks.add(1)
for ictr = 1 to 99
newwkbk.worksheets.add
next ictr

I'd end up with 100 worksheets in that new workbook.

JT wrote:

When you programmatically add a new workbook, is it possible to indicate the
number of sheets the new workbook should have?

Thanks for the help.......
--
JT

--

Dave Peterson