One method would be to remove the duplicate range names on the destination
sheet using code. (could affect existing formulas in the destination
workbook).

another would be to transfer the formulas as text strings

you would use the VBA equivalent to Edit=Replace

Replace
what =
with ZZ=

then do you copy and pastspecial values. (rather than formulas)

then reverse it on the new sheet and the old sheet.

Replace
What ZZ=
with =

You would need to consider which names you want to be used.

--
Regards,
Tom Ogilvy

"Mike Wrob" <Mike wrote in message
...
I tried it and I'm still getting the message boxes. Any other ideas?

"Tom Ogilvy" wrote:

Try
Application.DisplayAlerts = False
Selection.PasteSpecial Paste:=xlFormulas, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy