I am trying to create a VBA function that will take a variable number
of inputs. Is there a way to declare a variable number of inputs for
a function? I have found that if I don't use the total number of
inputs declared, I will get #Value. My thought is that a loop could
be created to count the number of inputs used in the statement in
Excel =myfunction(input1, input2, input3.....).

This is probably a simple problem but I haven't been able to find the
solution yet.