If worksheet name already exists?

[eti3nne]

I create a new worksheet based on the currently active sheet's name eg wc08Dec08 plus 28 days gives wc05Jan09 etc.

If the new name already exists, I get a warning message, the macro fails and a new sheet called eg Sheet 1 is created.

How can I write an 'if exists statement' to capture this condition and warn the user that they have tried to create a sheet already available and also to delete the new 'Sheet1'. (NB. This Sheet number may be variable?)

Thanks for looking.

 

[GlennUK]

Please ask VBA questions in forum707 .

Cheers, Glenn.

Beauty is in the eye of the beerholder.