checking for EOF in excel
 

Diana,

This will find the last used row number in column A.

Dim lrow As Long

lrow = Cells(Rows.COUNT, "A").End(xlUp).Row
MsgBox("The last row number is " & lrow)
--
sb
"Diana" wrote in message
...
I have a table in excel and I need to write a VB
procedure to check which row is the end one. Any
suggestions. I appreciate your help.
Diana