| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically adding formula to added cells
Hi, I am using EXCEL 2003. I have a simple formula in col b... =(a1).. which
I dragged down to produce =(A2) etc. If I insert a row anywhere in the range, it doesnt pick up the formula in col b. Is there any way that I can automate this ? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically adding formula to added cells
Have a look for worksheet change event
edvwvw Sapper wrote: Hi, I am using EXCEL 2003. I have a simple formula in col b... =(a1).. which I dragged down to produce =(A2) etc. If I insert a row anywhere in the range, it doesnt pick up the formula in col b. Is there any way that I can automate this ? Thank you -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200904/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically adding values to cells... | Excel Discussion (Misc queries) | |||
| Automatically adding cells with values | Excel Discussion (Misc queries) | |||
| Formula is being added automatically | Excel Discussion (Misc queries) | |||
| formula to sum the prior 12 cells regardless of added columns? | Excel Worksheet Functions | |||
| $ added to formula automatically | Excel Worksheet Functions | |||
Linear Mode
