Try

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

--
Jacob


"Victoria" wrote:

hi gurus

I have a 'novice' question. It refers to a table that can a variable number
of rows and columns. The cells of the table have lined borders. The upper
left cell of the table is "A3". I need code that produces the row number
of the LAST row in the table. (This row may have values in its cells or its
cells may be empty.)


thanks a lot