Adding multiple sheets in one go
 

Hi ,

I'd like to create a routine to add 12 sheets to a new workbook quickly
without having to do them one at a time. I get fed up adding them one at a
time.

Is this possible to do in Excel VBA?

Any help greatly appreciated.


Thanks in advance
Sandra

Adding multiple sheets in one go
 

While Worksheets.Count < 12 'or the number you want to end up with
Worksheets.Add
Wend


will do what you want, but if you ALWAYS want a certain number of
sheets, why not just set this in tools options?
Grd wrote:
Hi ,

I'd like to create a routine to add 12 sheets to a new workbook quickly
without having to do them one at a time. I get fed up adding them one at a
time.

Is this possible to do in Excel VBA?

Any help greatly appreciated.


Thanks in advance
Sandra

Adding multiple sheets in one go
 

sheets.add count:=12


Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=548961