View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Cell References in functions

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 ***