My Excel macro at several points performs some cut'n'pasting, and the dialog
box appears :
"A formula or sheet you want to move or copy contains the name 'Parnerlist'
which already exists on the destination worksheet. Do you want to use this
version of the name?"
I want the macro to accept a "Yes" programatically and carry on working.
I'm sure there's an easy answer but I haven't found it. Can anyone help?