Example code............

Sub SheetCopy()
Dim x As Long
Application.ScreenUpdating = False
shts = InputBox("How many times")
For x = 1 To shts
ActiveSheet.Copy After:=ActiveSheet
Next x
Application.ScreenUpdating = True
End Sub


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 13:09:01 -0700, ASteele
wrote:

I need to run a copy code an "x" number of times. The value for "x" is
variable and I would like to declare it within the code for the copy routine.

What is the easiest way for a beginner, like me, to write the code?