MULTIPLE COPYING OF ONE WORKSHEET

[jmh]

hello:
i have a worksheet with labels and formulas, (call it worksheet 2) and i
wouldlike to have multiple copies of it(worksheets 3-14). how do i accomplish
this?

excel 2007

 

[David Biddulph]

Right-click on the sheet tab, then take the "Move or Copy ..." option.

 

[Gord Dibben]

Sub SheetCopy12()
Dim i As Long
Dim ws As Worksheet
Set ws = Sheets("Sheet2")
On Error GoTo endit
Application.ScreenUpdating = False
For i = 14 To 3 Step -1
ws.Copy After:=ws
With ActiveSheet
.Name = "Sheet" & i
End With
Next i
Application.ScreenUpdating = True
endit:
End Sub


Gord Dibben MS Excel MVP