How to insert Worksheets

[sushantrao]

Hi All,

I want to insert 75 worksheet.Is there any easy way to insert more than 1 worksheet at a time.

Reagrds,
Sushant.

 

[Richard Schollar]

If they're blank worksheets, probably the easiest way is to go:

1. Tools>Macro>Visual Basic Editor
2. Open the Immediate Window (Ctrl+G shortcut)
3. Type in:

For i = 1 to 75: thisworkbook.worksheets.add:next i

4. Press return and sit back.

Best regards

Richard