Hi,
I'm relatively new to VBA and still learning. Just as an example I would like to replicate the excel SUM function in VBA.
my function in "Sheet1" code window looks like this...
![]()
Function sumexample(numbers As Range) sumexample = WorksheetFuntion.Sum(numbers) End Function
this doesn't seem to work...in excel i tried to call the function sumexample like this....=sumexample(A1:B2)
i get an error "#NAME?"...what am i doing wrong...how should it look?
thanks
Bookmarks