Auto-Handling of Named Range Existing in Destination Worksheet w/ VBA

[bonzo]

I'm using "WS.Cells(TempRow,TempCol).PasteSpecial Paste:=xlPasteValidation" in a VBA macro to paste copied cells from another workbook. As a result, I get the following popup window:

==============
A formula or sheet you want to move or copy contains the name "MY_MENU", which already exists on the destination worksheet. Do you want to use this version of the name?
* To use the name as defined in the destination sheet, click Yes.
* To rename the range referred to in the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box.
==============

I'm looking for a way to auto-handle this situation such that the "Yes" selection would be done without prompting the user for the choice. Is there a way to do this?

Thanks,

Bonzo

 

[JoeMo]

Try adding this before the paste line:
Application.DisplayAlerts = False

 

[bonzo]

Excellent, JoeMo! That worked Thanks...