Copy Worksheet - surpressing the "the name 'CLICKLIST' already exists." dialog

I've got a piece of VBA code, that clones a worksheet. (ie creates a copy of it in the same workbook)
The following dialog box is raised: "The name 'CLICKLIST' already exists. Click Yes to use that version of the name, or No to rename the version of 'CLICKLIST' you're moving or copying."

Is there a way to suppress this? I always want the 'Yes' option... (ie the list is the same name, and I refer to the list using the worksheet name)

Thanks!

Solved :|

Please Login or Register  to view this content.