I don't really understand the background <grin, but
perhaps a suggestion might solve the actual challenge ?

This is, to create a User Defined Function (UDF) that
will accept both discreet entries or a range - is that
right ?

How about something along the lines of ;

Function myAnswer(Optional myRange as Range, _
Optional myNum1, _
Optional myNum2, _
Optional myNum3, _
Optional myNum4, _
Optional myNum5, _
Optional myNum6, _
Optional myNum7, etc. ... )

Then, if the user is inputting a Range,
she just bangs it in

= myAnswer(F1:J7)

but if you want individual entries,
then you put a comma first,
e.g.
= myAnswer(,F1,J7,Q9,K9)

-----Original Message-----
I'm trying to create a function to calculate
the period of a sum of sinusoids.
....
I would like this
function to operate like the worksheet one,
in that you can place in the
argument up to 29 sine wave periods
separated by commas, or you can
enter a range (no commas).
......
This one works with a range,
but doesn't work if you input each period
separated by a comma.
Can anyone recommend a single function that will
accept both types of input?