Hi folks
My macro copys a sheet (template) and renames it by todays date
Sheets("Template (2)").Select
Sheets("Template (2)").Name = sName

How do I write:
if exist a sheet by the name sName
cancel the process , delete Template 2
else
Sheets("Template (2)").Select
Sheets("Template (2)").Name = sName
endif

thanks
JKohn
john
Images of home (NZ)
http:\\www.myplace.co.nz/home
What we are up to in the UK
http:\\www.myplace.co.nz