How do I select the first row of a table

J

John

What macro code do I use to select the entire i-th row of a table?

Application.Goto Reference:="TableA" selects the entire table, but I just
want a specific row selected.

Thx for your help, John
 
R

Ron de Bruin

Hi John

A real Table in Excel 2007 or a range named TableA ?

For a range use

Range("TableA").Rows(1).Select

If it is Excel 2007 Table this will select the first data row (row(2)
 
P

Per Jessen

Hi

With Headers in row 5 try this:

Rows(5+i).select

Or maybe

Range("TableA").cells(1,1).offset(i,0),select

Hopes this helps.
 
Top