| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Confused about relative references in named formulas
Ok, never mind. I guess I should have tried it first. What I didn't
realize is that the display of the named formula in the Define Named Formula dialog always shows relative references offset from the currently active cell, so the reference in the example wouldn't show "B22", it would show the cell address of the cell below the active cell (or B22, if the active cell was B21). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying formulas with different references | Excel Discussion (Misc queries) | |||
| How can I enable the "Record Using Relative References" option in. | Excel Discussion (Misc queries) | |||
| Relative worksheet reference in 3-D formulas? | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Relative addressing using names or labels in formulas? | Excel Worksheet Functions | |||
Threaded Mode
