| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula should retain
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 | |||
![T De Villiers[_29_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
