| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
working with a named range
hi all,
i'm looking to figure out how to use a named range and get its value into a new cell, but not the reference, the actual value ie dim loc as range loc.formular1c1="=NamedRange1" will put the reference to where NamedRange1 points - and will change when NamedRange1 changes. however i need the copy to be 'static' any suggestions? tia J |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy contents of a named range to a section on working area | Excel Discussion (Misc queries) | |||
| Named Range Links not working | Links and Linking in Excel | |||
| My Dynamic Named Range isn't working | Excel Worksheet Functions | |||
| Formula not working when letter A is used in a named range | Excel Discussion (Misc queries) | |||
| Create named range for each column not working? | Excel Programming | |||
![Gixxer_J_97[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
