Formula property

[Zain]

Hi

I need to add up the cells in a certain column but I have the row references stored in variables (of type Integer). So if upper and lower are the row references then the code I tried is:

ActiveCell.Formula = "=SUM(Cashflows!C & Upper:C & Lower)" .

This didn't work.

Help please?

 

[Dylan]

It should be this way.
ActiveCell.Formula = "=SUM(Cashflows!C" & Upper & ":C" & Lower & ")"

 

[Zain]

Thanks a lot!! I'm sure this is some sort of record for speediness.