Sunday 27 February 2011

VBA - Excel Sum Function in VBA Code

Title:
VBA - Excel Sum Function in VBA Code


Video:


Description:We create a VBA function called SumCode() that does the same thing the Sum Function does in excel to illustrate how functions work in VBA Function SumCode(rng As Range) sumx = 0 For Each cell In rng sumx = sumx + cell.Value Next SumCode = sumx End Function

Published:
28/Feb/2011

No comments:

Post a Comment