How do I select the first row of a table

[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

 

[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)

 

[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.