Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
PAL wrote...
Sometimes I get an error message, "You can't change part of an array". *Two cells apparently get linked. *How do I get out of this. If you want to 'unlink' the cells, meaning each of these cells' formulas would become regular formulas, hold down a [Ctrl] and a [Shift] key and double click on the cell with the problem formula to select all the cells in the array, press [F2] to edit the formula, then hold down a [Ctrl] key and press [Enter]. The formulas in all the selected cells will now be separate, regular formulas, but it's possible they may all return #VALUE!. That depends on what the formulas are. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) |