Thread: Copy worksheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
eksh eksh is offline
external usenet poster
 
Posts: 32
Default Copy worksheets

Hi MJ,

If you need the function very frequently, you may use the following code
Sub MacroCopyWS()

Answer = InputBox("How many worksheets you want to duplicate?", "Copy
worksheet", 30)

For i = 1 To Answer
ActiveSheet.Copy Befo=Sheets(1)
Next i

End Sub

"Bob I" wrote:

copy once, group the two, copy them, group the 4, copy
them..................

MJ wrote:

I want to copy the same worksheet 30 times in one workbook. Is that possible
without doing the copy worksheet 30 times?