Macro to Insert Worksheets and Name The sheets

[John Vieren]

Dear All,

Enclosed is my workbook with macros.

This workbook inserts sheets, then renames the sheet and copies a range with a specified format.

All is working except for 2 problems:

1) In pasting the range I am unable to paste values, although I am able to paste column width and formats.
2) If a duplicate worksheet name appears, I get an error message and the macro terminates. Is there a way to skip that and continue on with the other sheets?

Thanks for any feedback, John

[AB33]

I do not know what you are supposed to do when the sheet name already existed, though I have improved the code. You might still get errors.

[John Vieren]

Thanks you.

I will review your code and revert.

John