| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
named range, offset self-reference
Excel 2002, XP Pro
I have a named range, (eg) X = WS!B2:F2, and a formula in these cells (eg) B2 =A2+B1, which references a cell (B1) that is offset in the same range. Is there a way to use the range's own name (X) instead of B1 in this formula? Thanks, George |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| named range with filter | Excel Worksheet Functions | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
| Passing Excel NAMED Range to VBA | Excel Worksheet Functions | |||
| Dynamic named range across multiple sheets | Excel Discussion (Misc queries) | |||
| Question for use of offset and range | Excel Worksheet Functions | |||
Threaded Mode
