In Office 2003, when I right click a tab in a workbook and get the option of
'move or copy' is it possible to 'copy' a worksheet multiple times all at
once?
No, but if you make a copy once then you can select both those sheets and
right click and now you will get 4 copies and next time 8 and so on. So the
answer is no, not by using anything built in except for VBA
An easier way to copy a sheet is to hold down the control key and drag the
sheet (or sheets). When you do this you will see a + sign while dragging
indicateing you are copying the sheet. Doing this it does not take long to
get a fairly substantial number of copies.
An easier way to copy a sheet is to hold down the control key and drag the
sheet (or sheets). When you do this you will see a + sign while dragging
indicateing you are copying the sheet. Doing this it does not take long to
get a fairly substantial number of copies.
Copy once then select both sheets and copy again then select the 4 sheets
and copy again
Via VBA....................
Asign this macro to button or shortcut key combo.
Sub SheetCopy()
Dim i As Long
On Error GoTo endit
Application.ScreenUpdating = False
shts = InputBox("How many times", , 3) '3 is default
For i = 1 To shts
ActiveSheet.Copy After:=ActiveSheet
Next i
Application.ScreenUpdating = True
endit:
End Sub
I have done that at times but I really don't think it is easier
than selecting a group of sheets and then right click.
It's handy when you want to move a sheet a few steps (without using the ctrl
key)
but I feel like I have less control.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
