View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Last record in collumn.

Hi Tom,

Try:

Dim LastRow As Long

LastRow = Cells(Rows.Count, "A").End(xlUp).Row


---
Regards,
Norman



"Tom" wrote in message
...
Hello,

how can I find out by VB last record for example in column A (I need
number of row)? Is there some easy way...

Thanx tom