johnalexander
Board Regular
- Joined
- Feb 26, 2003
- Messages
- 50

let's say cell A1 contains a long formula which ends as follows:
....'C:\DATA\qfe\[D&P Deductible Adjustment.xls]D&P Deductible Adjustment'!T$4:T$17)
I want cell b1 to return the bottom row used in the reference (in this case, 17). This is a check for me to make sure that my ranges referenced are far down enough.
Anyone?