| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range Macro Formula
try this
range("sales").address -- Gary "Simon" wrote in message ... Hi There, How do you get the cell references of a named range. I need to create a formula within a macro which will be assigned to a particular cell, however I'm having trouble doing this. I need the cell references of the particular named range. The named range is only one cell eg. SALES is A5. Thanks Simon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Range Macro | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| How do I use a Macro to define a Named Range | Excel Programming | |||
| How to set named range in macro? | Excel Programming | |||
| How do I get a macro to ask for a 'range' to go to with a choice of Named ranges? | Excel Programming | |||
Linear Mode
