Dear friends..

i want your help regarding this subject.. can anyone help me?

actually, i have a big database in excel.. dont want to go last and first...
i want to know in certain cell (B1) which is the last entry had done in A:A.

thanks in advance


suresh tp

Hi Suresh,

Your question is not clear but perhaps try::

'=========
Public Sub aTester()
Range("B1").Value = Cells(Rows.Count, "A"). _
End(xlUp).Value
End Sub

'<<=========


---
Regards,
Norman



"SURESH" wrote in message
...
Dear friends..

i want your help regarding this subject.. can anyone help me?

actually, i have a big database in excel.. dont want to go last and
first... i want to know in certain cell (B1) which is the last entry had
done in A:A.

thanks in advance


suresh tp