Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a spreadsheet that has lots of Named Formulas (to ensure consistancy and avoid errors). Each formula refers to data in the three rows directly above it (i.e. in the same column). The formula is repeated further down in each column referring to more data. I've been asked to insert a new row into each set of data, however when I do this the named formulas don't automatically adjust for it in the way that a directly inserted formula would i.e. the new row is referenced when I'd rather point to the original cells. I presume this is due to the fact that the formulas are relative rather than absolute. Since the formulas are very complex I don't want to manually adjust them in the Named Range box. The only thing I can think of is to convert them all to normal formulas, insert the new row, then convert back to named ranges. Is there way to sort this out? Best Regards, CalumMurdo Kennedy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
converting formulas to code | New Users to Excel | |||
Converting formulas to values | Excel Discussion (Misc queries) | |||
Converting formulas to value | New Users to Excel | |||
Using Named Formulas | Excel Worksheet Functions | |||
Want Help Converting Excel Links to Named Cells (i.e. 1 cell Ranges) | Excel Programming |