D
Dan
How do I add and name 2 new worksheets to my workbook? I
had previously deleted a worksheet and thought that the
new sheet would be sheet1 but my code error because new
sheet was sheet2. I want to add 2 sheets called "Final"
and "ScrubData".
I had:
Sub InsertWorksheets()
Dim i As Integer
i=Sheet.Count+1
' I error out here
Sheets(i).Add
ActiveSheets.Select
ActiveSheet.Name="Final"
....confused.
Can someone help this newbie? Thanks.
had previously deleted a worksheet and thought that the
new sheet would be sheet1 but my code error because new
sheet was sheet2. I want to add 2 sheets called "Final"
and "ScrubData".
I had:
Sub InsertWorksheets()
Dim i As Integer
i=Sheet.Count+1
' I error out here
Sheets(i).Add
ActiveSheets.Select
ActiveSheet.Name="Final"
....confused.
Can someone help this newbie? Thanks.