J
john
I am attempting to create a new worksheet in a macro and
give it a specified name. I can create the worksheet with
the following command:
ActiveWorkbook.Sheets.Add After:=Worksheets("test")
What I can't figure out is how to name the newly created
worksheet.
Anyone have an idea on how to do this?
give it a specified name. I can create the worksheet with
the following command:
ActiveWorkbook.Sheets.Add After:=Worksheets("test")
What I can't figure out is how to name the newly created
worksheet.
Anyone have an idea on how to do this?