Thread
:
how do you SUM in VBA code
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson