"Harlan Grove" wrote in message
oups.com...
Fredrik Wahlgren wrote...
...
You can use a UDF like the one below. It will ignore things in the
passed
range which are not numbers.

Why use a UDF rather than an array formula like

=MAX(IF(ISNUMBER(rng),rng))

?

Right. Your solution is nicer

/Fredrik