Using macro to create a new sheet if that sheet doesn't already exist

[jhelliar]

I was hoping someone would be able to let me know if this is possible.

I need a macro to create a new sheet with a specific name and put certain data on to it (this part I can write later)

What I also need is for it not to create a new sheet (or do any of the rest of the macro) if that specific sheet name already exists e.g. can't run the same macro twice without deleting the sheet.

E.g. Macro creates new sheet called "Dave" when run. If the workbook already contains the "Dave" worksheet then if the macro is run it gives an error message saying "Dave already exists" and rest of macro doesn't run.

I hope this makes sense. Any help would be gratefully received

[Fluff13]

How about

Please Login or Register  to view this content.

[davesexcel]

Loop through sheets to see if sheet exists

Please Login or Register  to view this content.

[mikerickson]

Please Login or Register  to view this content.