Try:

Function Span(rng As Range) As Double
With Application
Span = .Max(rng) - .Min(rng)
End With
End Function

---
HTH
Jason
Atlanta, GA

-----Original Message-----
I'd like to be able to define my own functions in
Excel... for example: SPAN
could calculate the span of values in a selection
(highest minus lowest) with
a single function rather than using MAX(C#R#:C#R#)-MIN
(C#R#:C#R#) all the
time.
.