You could use a macro like this:
Option Explicit
Sub InsertWorksheets()
Dim HowMany As Long
Dim iCtr As Long
HowMany = CLng(Application.InputBox(Prompt:="How many?", Type:=1))
For iCtr = 1 To HowMany
Worksheets.Add after:=ActiveSheet
Next iCtr
End Sub
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Then to run it, you can just:
tools|macro|macros (or alt-F8)
select InsertWorkbooks and click run
The workbook with the macro in it needs to be open.
Carole Drake wrote:
I'm kind of new to macros - how would you go about using one for this?
"Dave Peterson" wrote:
Even inserting from the Insert|worksheet will insert before the activesheet.
I think if the OP wants more control, a macro would be in order.
"lady-pearl" wrote:
On my current Workbook I would like to insert anywhere from 1 - 10 extra
worksheets, but I notice that when I do the "insert worksheet" they are not
always consecutive. I am finding that I have to drag them back to the place
where I want them to appear originally.
Thanks!
Pearl
--
Dave Peterson
--
Dave Peterson
--
Dave Peterson