Can I pass a range to a paramarray argument?

[JenniferMurphy]

This function works if I pass it a list of cell addresses, like =Rangesum(C4,D4,E4)

Function RangeSum(ParamArray list())
Dim i As Integer
RangeSum = 0
For i = 0 To UBound(list)
  RangeSum = RangeSum + list(i)
Next i

But it gets a value error if I call it with a range, like "RangeSum(C4:E4)" or "RangeSum((C4:E4))".

Is there any way to write the function so that both calls will work, like the Sum function, which works either way?

=Sum(C4,D4,E4)
=Sum(C4:E4)

 

[footoo]

VarType Function : https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/vartype-function

 

[JenniferMurphy]

Yes, this is an array constant.

OK. I'm not sure where I would ever use that, especially since I barely use arrays at all, but I'll keep that link handy.

Thanks

 

[JenniferMurphy]

VarType Function : https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/vartype-function

Aha. So that's how Rick fixed his function. Thanks.