PDA

View Full Version : Multiple copies of Active Worksheet



r_mundhra
08-17-2008, 01:56 AM
Dear All

Can anyone help me with a code that can make multiple copies of the active worksheet.
Thanx/R Mundhra

Bob Phillips
08-17-2008, 04:01 AM
Dim i As Long

For i = 1 To 5

ActiveSheet.Copy after:=Worksheets(Worksheets.Count)
Next i

r_mundhra
08-17-2008, 06:29 AM
Thanks for the code
r_mundhra