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

did you try active.worksheet ?



CEsar





"Paul W Smith" wrote in message
...
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"



"Paul W Smith" wrote in message
...
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