how do you SUM in VBA code

  • Thread starter Thread starter Barmaley
  • Start date Start date
B

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
 
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
 
Back
Top