sheet name used ?

[Corey]

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

 

[Bob Phillips]

On Error Resume Next
Set sh = Worksheets("sheetname")
On Error Goto 0
If sh Is Nothing Then
'do your stuff
End If

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)