Accessing cells in an 'uneven' table

J

Jay

Hi,

I know that you can use cell(row, col) to access a particular cell in
a table. But what if some cells have been merged and others have been
split, which makes the definition of row and col tricky. Is there
still a way to access individual cells?

Thanks,

Jay
 
J

Jezebel

Read Help on the RowIndex and ColIndex properties.

You can also iterate the cells sequentially using the .Next and .Previous
properties for each cell.
 
T

Tony Jollans

You can use TableRef.Range.Cells(n) to access an individual cell.

You can get a nominal Row and Column by examining the RowIndex and
ColumnIndex properties but you cannot use these to access the cell.

The Next and Previous properties will navigate through the table but not in
quite the same way as using Tab (which nominally does a NextCell).
 
Top