hi again

I'm using Excel 2002. I'm not sure what you mean by a '2007 table', but I'm
simply refering to an area of the Sheet that has bordered cells. If printed,
it would look like a sheet of graph paper. I need to be able to identify the
last row, even if its cells contain no values.

Sorry if I'm using terms improperly
Victoria

"Jacob Skaria" wrote:

--Which version of XL do you use...
--Are you referring to 2007 table

--
Jacob


"Victoria" wrote:

hi Jacob - your code snippet works well when there is an entry in the cell.
But the cells may be empty. Every cell in the table has a line border on
all 4 sides (When printed, many cells will be empty, but workers fill in
values for later data entry.) What I need is to be able to identify the row
number of the last formatted row.

Thanks
Victoria

"Jacob Skaria" wrote:

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