| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I insert a row and keep all the formulas in the cells?
I am making a commission excel sheet and I want to make a macro to insert
cells for the sales people to press so they don't have to select Insert and Rows from the menus. The macro inserts the row just fine but two things are happening. 1. The cells on the line are all blank, they are not copying the formulas from the cell on or above. (actually while typing this i think i have figured this one out) but more importantly... 2. The SUM fields are not updating after running my insert macro... Suggestions... Tom Cusick Tech Support Servant PC Resources, Inc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas Affected by Insert Row | Excel Worksheet Functions | |||
| Insert description into own Formulas | Excel Worksheet Functions | |||
| insert two formulas one cell | Excel Worksheet Functions | |||
| formulas after insert row | Excel Programming | |||
| Need to insert formulas into certain cells when row inserted | Excel Programming | |||
Threaded Mode
