Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name conflict
I want to copy a range from one workbook to another. Within the range is
a reference to a named range which exists in both workbooks. I want it to use the name in the destination workbook. At the moment I get an Excel message saying: "A formula or sheet you want to move or copy contains the name 'name', which already exists on the detination worksheet. Do you want to use this version of the name?" It gives a choice Yes or No. I don't want this message to appear and I always want to choose "Yes". I can't just send an enter keystroke because if there is a different error such as the ranges being a different size I want to be alterted. Any suggestions ? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name conflict
If you aren't doing any formula adjustments
Workbooks("Book2.xls").Worksheets("Sheet3").Range( "A1:F32").Formula = _ ThisWorkbook.Worksheets("Sheet1").Range("A1:F32"). Formula -- Regards, Tom Ogilvy "John Turton" wrote in message ... I want to copy a range from one workbook to another. Within the range is a reference to a named range which exists in both workbooks. I want it to use the name in the destination workbook. At the moment I get an Excel message saying: "A formula or sheet you want to move or copy contains the name 'name', which already exists on the detination worksheet. Do you want to use this version of the name?" It gives a choice Yes or No. I don't want this message to appear and I always want to choose "Yes". I can't just send an enter keystroke because if there is a different error such as the ranges being a different size I want to be alterted. Any suggestions ? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name conflict
Thanks - so simple and it works
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Name conflict | Excel Discussion (Misc queries) | |||
Name Conflict | Excel Discussion (Misc queries) | |||
Name Conflict | Excel Discussion (Misc queries) | |||
Name Conflict Error | Excel Worksheet Functions | |||
Name Conflict Dialog Box??? | Excel Discussion (Misc queries) |