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