Code Required To Avoid Error on Worksheet Insert

[GDUBBS780]

Worksheet Title: "Summary"
Column A, starting in row 2:
A
B
C
D

The code below effectively creates and renames four (4) worksheets "A", "B", "C" and "D". But, if I add a row with "E" and run the macro, I get an error basically saying A, B, C and D already exist so you are screwed....

I need to insert code that will allow me to create only new worksheets for the new data in column A. Thank you so much for your help.

Please Login or Register  to view this content.

[DonkeyOte]

Please use CODE tags when posting VBA to the board.

In answer to your question - validate existence of sheet prior to addition:

Please Login or Register  to view this content.