Insert multiple Excel worksheets
|
Macro Title:
|
|
Worksheet Variable:
|
|
Worksheet Name:
|
|
Cell Reference:
|
|
First Comment:
' |
|
Second Comment:
' |
Sub Insert_Multiple_Worksheets()
'declare a variable
Dim ws As Worksheet
Set ws = Worksheets("Parameters")
'insert new worksheets in front of an active sheet using a cell reference that captures a value that represents the number of new worksheets to be inserted
Worksheets.Add , Count:= ws.Range("A1").Value
End Sub