Home |
Search |
Today's Posts |
#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. |
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) |