Hi,

If you look at the ordinary =SUM() function, this takes two types of
input: Numbers and ranges.

I.e., you can either write

=SUM(A1:C3) or =SUM(1,2,3)

I would like to create an UDF which accepts the same, but how to define
the input type???

If I do this:

Function UDF(ValueRange as Range)

....it will only accept range as input, and not numbers???

Help appreciated, please?


CE