View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T[_8_] Peter T[_8_] is offline
external usenet poster
Posts: 88
Default Changing workbook name in named cell

"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