msgbox on duplicate sheets

[deletedalien]

Good morning, i have the following code:

Please Login or Register  to view this content.

what i need it to do is just inform the user when there was already a sheet with that name (corrected by using sh.Name = sName)

However when there was not a duplicate theres no need for the msgbox.

Also this code is called by

Please Login or Register  to view this content.

but when i run it the msgbox popsup regardless of duplicate or not

Thanx in advance for your help.

[mojo249]

Hi

'On Error Resume Next' ignores all error messages and continues with the next line of code. Try the following:

Please Login or Register  to view this content.

[deletedalien]

Awesome aswesome awesome!!!!!!!!!!

Thank you x10000