Create copy of sheet & rename

[Vetequk]

I am trying to copy a sheet, then rename the using the value in cell C6 +1. I am having trouble making the newt sheet avtive for the renaming process.

I would need to place this code into a loop to create 75 sheets.

I have attached a test file with the code.

Thanks

Vetequk

[royUK]

You don't need to activate the new sheet, it will automatically be the active sheet

Please Login or Register  to view this content.

[Vetequk]

That work great thanks

Vetequk