On 2002-11-09 02:04, TsTom wrote:
[...]Using Excel functions
=ROW(MyRange)+ROWS(MyRange)-1
[...]
Tom,
That won't work (neither will what Yogi suggests),
unless it's just a question of establishing the last row of myRange irrespective of whether the last row is in use.
Otherwise...
If myRange is of numeric type...
=MATCH(9.99999999999999E+307,myRange)
If myRange is of "text" type...
=MATCH(REPT("z",90),myRange)
If myRange is of mixed type...
=MAX(MATCH(9.99999999999999E+307,myRange),MATCH(REPT("z",90),myRange))
Note that you can replace 9.99999999999999E+307 with BigNum in the above formulas by defining BigNum as follows...
(1.) Activate Insert|Name|Define.
(2.) Enter BigNum in the Names in Workbook box.
(3.) Enter the following in the Refers to box:
9.99999999999999E+307
(4.) Click OK.
Aladin
PS. I believe muffins wants a VBA solution.
This message was edited by Aladin Akyurek on 2002-11-09 02:48
This message was edited by Aladin Akyurek on 2002-11-09 02:53