LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Converting to and from Named Formulas

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
converting formulas to code tofimoon4 New Users to Excel 4 October 11th 10 01:01 PM
Converting formulas to values Byron720 Excel Discussion (Misc queries) 3 July 10th 08 06:39 PM
Converting formulas to value Gene L. New Users to Excel 2 June 30th 08 01:39 PM
Using Named Formulas General Specific Excel Worksheet Functions 2 August 18th 07 07:13 PM
Want Help Converting Excel Links to Named Cells (i.e. 1 cell Ranges) orangepips Excel Programming 1 November 23rd 05 07:31 PM


All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"