| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference a named range
My data spreadsheet has several named ranges, with meaningful names. I'd like
to refer to them in VBA, but all attempts so far lead me to absolute addresses like $R1$C1, or sheet1!R23C45. If a user cselects a named range how can I read the name of the range (that might be a sinlge cell) and how can I write to another named range (that will have many cells)? Many thanks whoever is out there. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference first cell in a named range | Excel Worksheet Functions | |||
| Simple: how to express this named-range reference? | Excel Discussion (Misc queries) | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Named Range reference via single Cell | Excel Discussion (Misc queries) | |||
| named range, offset self-reference | Excel Discussion (Misc queries) | |||
![John M.[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
