I think what you want is:

=LOOKUP(9.999E+307,B1:AZ1)

entered in cell A1. This will find the last value entered in the range
B1 to AZ1 - adjust to suit your situation. If you want to find the
(relative) position of this cell, use MATCH.

Hope this helps,

Pete