I recorded the following macro:
The problem is that I'm going to be adding multiple sheets. Which brings me to my question: How can I change the name of the sheet that I just added?Code:Sheets("Sheet2").Select Sheets.Add Sheets("Sheet2").Select Sheets("Sheet2").Name = "name"
Thanks,
Alex




Reply With Quote