You would need a macro.

Sub Sheets_Add()
For i = 1 To 3
Sheets.Add
Next i
End Sub

If you wanted to get specific, you could give them names also.

Sub Add_Sheets()
For i = 3 To 1 Step -1
Worksheets.Add.Name = "sugar" & i
Next
End Sub


Gord Dibben MS Excel MVP


On Sun, 25 Jun 2006 11:03:02 -0700, sugar
wrote:

how would you simuletaneously insert three blank worksheets into a workbook