Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook "Sales" which has a cell named "price" referring to "Sales!$H10". If I save the workbook as "Sales.Foreign" I want the cell "Price" now to refer to "Sales.Foreign!$H10". However, program does not allow it.
The cell "Price" continues to refer to "Sales!$H10", in other words it does not accept the new workbook name. Any idea how to get around that? Many thanks for all help. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"programmernovice" wrote in message
I have a workbook "Sales" which has a cell named "price" referring to "Sales!$H10". If I save the workbook as "Sales.Foreign" I want the cell "Price" now to refer to "Sales.Foreign!$H10". However, program does not allow it. The cell "Price" continues to refer to "Sales!$H10", in other words it does not accept the new workbook name. Any idea how to get around that? Many thanks for all help. I assume your workbook has a worksheet named "Sales", same as the original workbook name. When you rename the workbook it will still include the worksheet named "Sales", and the Name will continue to refer to it. If you rename the worksheet the Name should automatically update. If there's more to this please give details of what you are working with, for example are multiple workbooks involved with a Name referring to a cell in a different workbook, what is the code that fails, etc Peter T |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I assume your workbook has a worksheet named "Sales", same as the original workbook name. When you rename the workbook it will still include the worksheet named "Sales", and the Name will continue to refer to it. If you rename the worksheet the Name should automatically update. You are absolutely correct and I should have known that is the reason. I appreciate your help, Peter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying a named range with a changing cell reference | New Users to Excel | |||
Copying a Named Range with changing cell references | Excel Programming | |||
Please Help! Copy named range to new workbook without changing references. | Excel Programming | |||
Copy a Named Range to a New Workbook without changing the Reference | Excel Programming | |||
Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) |