Hi,
I am copying by program a range of cells from one book to another. These
cells, which I want to copy, contain formula with names defined at workbook
levels. The workbook destination contains same defined names. When a program
copies cells from one workbook to another workbook Microsoft Excel displays
for each name the following prompt indicating name conflict.
"A formula or sheet you want to move or copy contains the name 'aaaa', 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".
My response is Yes for all names.
My question is How can I give the response automatically with VBA, is there
any parameter to VBA “paste” command which will replace the prompt of Excel.
Thanks in advance.

Does "Application.DisplayAlerts = False" not work for this? I've not tried
this particular situation so I am "grabbing at straws".
--
Best wishes,

Jim


"Warda" wrote:

> Hi,
> I am copying by program a range of cells from one book to another. These
> cells, which I want to copy, contain formula with names defined at workbook
> levels. The workbook destination contains same defined names. When a program
> copies cells from one workbook to another workbook Microsoft Excel displays
> for each name the following prompt indicating name conflict.
> "A formula or sheet you want to move or copy contains the name 'aaaa', 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".
> My response is Yes for all names.
> My question is How can I give the response automatically with VBA, is there
> any parameter to VBA “paste” command which will replace the prompt of Excel.
> Thanks in advance.
>