Patch

You cannot copy multiples of the same sheet at once unless you have multiple
copies of the sheet.

In that case you could select all copies of Sheet1 and use the "move or copy"
feature.

You have one other response describing how to double up to create multiples of a
sheet.

OR you could use a macro.............

Sub SheetCopy()
Dim i As Long
On Error GoTo endit
Application.ScreenUpdating = False
shts = InputBox("How many times")
For i = 1 To shts
ActiveSheet.Copy after:=ActiveSheet
Next i
Application.ScreenUpdating = True
endit:
End Sub


Gord Dibben MS Excel MVP

On Fri, 29 Sep 2006 01:15:51 -0700, Patch
wrote:

How are you all,

i was wondering if it was possible to copy more than one sheet at a time - i
have a work book and i need to make multiple copies of one particular sheet,
when i right click on a work sheet tab there are the options there - one of
them is move or copy - when you copy it askes where to put it, when you do
that it only comes up with one extra sheet - is it all possible to paste a
few more at a time than just one?

Thanks heaps Patchie