Hello,
I would like to create a macro in Excel 2007 that would enable me to do subtotals in a quote (including subtotals but excel does not take into account the overall total).
The sub total is to be done (for example) in Column D. In column E to the line above is the number of cells that are "in Total" , I can do it without any difficulty with the wizard function, but it's hard to do the same thing in VBA.
Basically if I did this :
can you tell me how to solve this problem , please help me thanks in advanceDim nbcell As Double
ActiveCell.Select
Selection.ClearContents
Nbcell = ActiveCell.Offset (-1, 1). Range ( "A1"). Value
Nbcell nbcell *= -1
ActiveCell.FormulaR1C1 = "= SUBTOTAL (9, R [-3] C: R [-1] C)"
Bookmarks