Hi Karl,
stalemate? Wait a minute you're not trying to place a formula
just get the row. Perhaps it is possible.
see formulas in
Lastcell, Reset Last Used Cell
Some Worksheet Function coding for lastcell in column (#formulas)
http://www.mvps.org/dmcritchie/excel...l.htm#formulas
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Karl" wrote in message ...
JMB,
Thanks. Sadly I have never used VBA and on the workbook I can only use
formulas to get there. It is not mine and has a LOT of macros that I would
rather not chance messing up.
Karl
--
Karl
"JMB" wrote:
The only way I know to do it is to use VBA. ......