View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thomas Cusick Thomas Cusick is offline
external usenet poster
 
Posts: 1
Default 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.