| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sustaining Range Definitions in a Function
I have a workbook where one sheet is linked to another. I have a formula
that references a range similar to A1:A500. But whenever I delete rows from the sheet that this formula is linked to it changes the reference to something like this A1:A492. I would like to be able to force this range to always stay the same no matter what. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sustaining Range Definitions in a Function
try
Indirect("A1:A500") "hoftenkrabb" wrote: I have a workbook where one sheet is linked to another. I have a formula that references a range similar to A1:A500. But whenever I delete rows from the sheet that this formula is linked to it changes the reference to something like this A1:A492. I would like to be able to force this range to always stay the same no matter what. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| vlookup function does not work when range is hidden | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Refer to Named Range on another sheet for IF function | Excel Worksheet Functions | |||
| Number range function | Excel Discussion (Misc queries) | |||
Linear Mode
