how do you SUM in VBA code

[Barmaley]

this statement
Fore = ForecastV + sum(actl(1):actl(10))

has problem with ":"
I must be missing very simple but cannot see it today

Can you help me

Thanks

 

[Chip Pearson]

Try something like

Fore = ForecastV + Application.Sum(Range(Act(1), Act(10)))

 

[Barmaley]

that didn't work, but I did work around that works. I didn't have much time
to fool around with sintax.
But I always appretiate help from this newsgroup

s_act = 0
s_for = 0
For rr = 1 To 18
s_act = s_act + actl(rr)
s_for = s_for + forcst(rr)
Next rr
Fore = ForecastV + s_act - s_for