View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default how do you SUM in VBA code

Try something like

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Barmaley" wrote in message
...
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