Andrew,
If we pass the operator as another parameter, it is quite easy, such as
=d(A12,"^5")
The UDF is then
Function d(rng, op As String)
If rng.Cells.Count 1 Then
d = CVErr(xlErrRef)
Else
MsgBox rng.Address
d = Evaluate("(" & rng.Value & op & ")-(" & rng.Offset(-1, 0).Value
& op & ")")
End If
End Function
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Andrew Smith" wrote in message
...
Thanks, this is great! Suppose I wanted to add the possibility of
nested functions within the timeseries. For instance, d(a12^5). Do you
know of a command like isrange that would allow me to figure out that
the input wasn't a range and go through a separate processing loop. I
notice that if I dim rng as Variant it will still work ok for the range
way.
Thanks,
Andrew
*** Sent via Developersdex http://www.developersdex.com ***