Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a worksheet containing 2 array formulas. If I insert rows within the
cell reference range the formulas appear to automatically update to reflect the new rows BUT the formula no longer returns a result just #NA. Is there a way to prevent this and allow row insertions? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Most likely, inserting rows will not impact the array formula's ability to
function. Without your formula, though, it's difficult to say. However, is it possible that your formula returns #NA! if there are blank cells in the referenced range(s)? Test by clearing the cells in one of the referenced rows (not deleting it). Then Edit|Undo to put the values back. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Chris" wrote: I have a worksheet containing 2 array formulas. If I insert rows within the cell reference range the formulas appear to automatically update to reflect the new rows BUT the formula no longer returns a result just #NA. Is there a way to prevent this and allow row insertions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
Unexpected (?) behaviour of OFFSET() in array formulas | Excel Discussion (Misc queries) | |||
Insert rows | Excel Worksheet Functions | |||
INSERT ROWS WITHOUT SCREWING-UP FORMULAS! | Excel Worksheet Functions |