Raddyer,

This works perfect.....Thanks a bunch!



"Ragdyer" wrote:

Using Row1,

For *numeric* data *only*:
=LOOKUP(9.99999999999999E+307,1:1)

For *text* data *only*:
=LOOKUP(REPT("z",255),1:1)

For text or numbers:
=INDEX(1:1,MAX(MATCH({"zzzzzzz",9.9999999E+307},1: 1)))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"BGarcia" wrote in message
...
What function or macro would I use to return the last list information in
a
given range of row even when some cells are left blank?