find (constant & varible) and replace with (contstant)

[newbie3]

I'm trying to find and replace 2 new worksheets sometimes "sheet 1" and "sheet 2" and sometimes "sheet 3" and "sheet 4" with the sheet name "city" and "zip".

My macro deletes the sheets "city" and "zip" in the beginning of the macro and adds new worksheets (ie. sometime "sheet 1" and "sheet 2" and replaces them with "city" and "zip" - the only problem is I run the macro several times so when I run the macro a 2nd time it adds sheet 3 and sheet 4 etc.) I'm new at this so hopefull someone can help. I currently only know how to record macros. Thanks!

 

[PHV]

How do you add the new worksheets ?
A starting point:
ActiveWorkbook.Sheets.Add
ActiveSheet.Name="zip"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244