Issue: same named cells in two different workbooks

[Gringoire]

Hello guys,
I have to programmatically copy and paste some ranges (sheet rows) from an Excel file to another Excel file.
During the Copy & Paste procedure, the code stops and Excel asks for choosing if maintain the old reference or use the new one for the cells having the same name in both files.

I must avoid that the routine stops waiting for User input and force it to always choose the new reference, but I have no idea on how to proceed.
do you have some hints?

The code is a simple

Selection.Insert Shift:=xlDown

Thank you.

 

[Muhammad_Usman]

Try this one

It sounds like you want to suppress the "Update Values" prompt that appears when copying and pasting cells from one Excel file to another. You can do this programmatically by disabling the alert dialogs. Here's how you can achieve this in VBA:

```vba

Application.DisplayAlerts = False
' Your copy and paste code here
Application.DisplayAlerts = True

```

This code turns off alert dialogs, so Excel won't prompt you when it encounters the same named cells. Just make sure to turn them back on by setting `Application.DisplayAlerts = True` after you've finished the copy and paste operation. This will ensure that other alerts, such as overwrite confirmation, are not suppressed after this specific operation.

 

[Gringoire]

Thanks for your prompt reply but it does not works.

Application.DisplayAlerts = False

works if there is no decision to get.
In this case the code cannot decide by himself which reference should be used and it stops anyway.

I had a similar issue in the past when the code stopped to ask for a choice about the printer to be used. In that case I solved simply assigning a printer as default printer.
In this case I do not know how to programmatically "assign" the new workbook as default reference for the named cells coming from the old one.