function w/ dynamic inputs

Hello tadwegner,

First, your macro needs to be a Function, not a Sub, and second, you can use a dynamic list by declaring it as a ParamArray. This declaration has to be the last argument in the function and must be a Variant. Nums holds the array of numbers returned from the cells. There can be none to as many as you list.

Function sss(ParamArray nums() As Variant)
...

End Function

Sincerely,
Leith Ross