Referencing a new worksheet

  • Thread starter Thread starter Paul W Smith
  • Start date Start date
P

Paul W Smith

How do I refer to a new worksheets created by copying an existing sheet.

I have the following code:

worksheets("Test").copy after:=worksheets(worksheets.count)

This creates a new worksheet called "Test (2)", I now want to be able to
rename that newly created worksheet.

I thought worksheets(worksheets.count) would always be the last create
worksheet, but this does not seem to be the case.

Can someone please tell me how to reference a newly created worksheet.

Paul Smith
 
well. in this case that will be the active sheet. then you can do
activesheet.name = "NewSheet"
 
Back
Top