Hi David

If the data in MSE is text, then
=MATCH(LOOKUP("zzzzz",MSE),MSE,0)
You could use REPT("z"),255) in place of "zzzzz" if that is not enough
to be text that could not be found.
It will of course only return 30, not 31 as there are only 30 elements
in the range

If the data is numeric, you could use
=MATCH(LOOKUP(99^99,MSE),MSE,0)
--
Regards

Roger Govier


"David" wrote in message
...
I have 3 Named Ranges that change as data is added. Unfortunately, they
are
all in Column A.
I need a function that will tell me the row number of the last row
with data
in the named range. If I can get one to work, I can do the other two.
One of the range names is MSE and is currently A2:A31. In this
example, I'm
looking for a function that will return 31.
Thanks!