For loop inside for loop starts over.

Hello.

The macro below copys a template sheet to last in order and renames it by a list in range "AD7". Im trying to make the code skip one iteration if a sheet with the name in range allready exist to next name in range.
The code now makes first sheet from first name in range then errors out in "cannot create a sheet with an allready existing name"

And when i run the code and all sheets is allready created the code should just skip every iteration and end.

Could anyone help me to what i need to change/ad in code below for it to work and not error out on when sheet with sheetname from range allready exists?

thanks for all the help!

Please Login or Register  to view this content.

Cheers

Thanks for the reply!

And thanks for the better option in code, have changed it now.
There are no duplications in the range, But when i run the code it copys the template and renames it with first name in range.
Then it copys the template again but error out with runtime error 1004. says it cannot rename the recently copied template with the name of an allready existing one.

so for some reason im guessing its trying to rename it with first name in range. if i remove the if statement code works fine, copies up the template and renames em one for every name in range.

I would like to build it for when the range later on gets additional names. so it could loop through (After run first time) and add only the missing sheets.

Se example workbookfile

Cheers

Thanks For that Andy!!

Works perfect now!

Never mind my second to last post. Didnt see your reply until after!

Thanks for the help there!

Rep Added for Both!

Cheers