Creating sum formula using vba
I need to sum every forth row between a start and end row. When I record a
macro, I get
"SUM(R[-60]C,R[-56]C,R[-52]C,R[-48],....,R[-4]C)"
If I know that I need to sum every forth row from row 3 to 59 in column E of
the active worksheet, how would I program this? I don't quite get the R[]C
format created by the macro recording.
Thank you,
QB
|