Unbelievable! That was cool.

Thank T.Valko


"T. Valko" wrote in message
...
Here's a non-array version:

Normally entered:

=ADDRESS(ROW(rng),MATCH(TRUE,INDEX(rng<"",0),0)+C OLUMN(rng)-1,4)

--
Biff
Microsoft Excel MVP