last entry from selected area

  • Thread starter Thread starter SURESH
  • Start date Start date
S

SURESH

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

'<<=========
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

last entry from certain area 1
last entry from a certain area 2
last entry done in certain area 1
COPYING FILES 1
Email from Excel with Outlook Express 3
FUNCTION 4
REPEAT SOME ACTION IN MACRO 2
Macro to delete last entry of a column 5

Back
Top