I have a code to create a copy of a sheet, and re-name it.
I have put a :
if res="" then
exit sub

but if res= 'An existing sheet name already' How do i write this?

if res=sheets.name ?

???


Regards

Corey