Hello,

I am trying to write a Macro that will sum a range of numbers and then go down to the next range of numbers, hten go to the bottom of that range to where I wnat the Sum and then total the second range.

I have tried recording the Macro using keystrokes but it keeps putting the Row,Col range in the Macro.

Here is what I have so far.


Selection.End(xlDown).Select
ActiveCell.FormulaR1C1 = "=SUM(R[-4]C:R[-1]C)"
Range("L9").Select
Not all the ranges have the same number of rows in them.

any help is greatly appreciated.

Regards

tattoo