| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula should retain
It isn't, but it is the only way (at least that I know of).
What specifically is not flexible about it, there may some tweaks to use? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "T De Villiers" wrote in message news:T.De.Villiers.2aipgz_1152179104.2158@excelfor um-nospam.com... Hi, In A1 I have formula sum(A3:A12), however when I insert a line in the range, the formula changes to sum(A4:A13), however I would like the formula to stay the same. An idea is sum(Indirect("A3:A12")), however this isnt very flexible. Many Thanks -- T De Villiers ------------------------------------------------------------------------ T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479 View this thread: http://www.excelforum.com/showthread...hreadid=558787 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move Column Retain Formula | Excel Discussion (Misc queries) | |||
| How to delete/change the formula of a cell and yet retain its cont | Excel Worksheet Functions | |||
| retain formula in additional workbooks | New Users to Excel | |||
| Can I retain a formula in the cell pasted to? | Excel Worksheet Functions | |||
| Is there a way to retain a formula while performing cut/paste? | Excel Worksheet Functions | |||
Threaded Mode
