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
Jezebel - 27 Oct 2005 12:16 GMT
Read Help on the RowIndex and ColIndex properties.
You can also iterate the cells sequentially using the .Next and .Previous
properties for each cell.
> Hi,
>
[quoted text clipped - 6 lines]
>
> Jay
Tony Jollans - 27 Oct 2005 13:43 GMT
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).
--
Enjoy,
Tony
> Hi,
>
[quoted text clipped - 6 lines]
>
> Jay
Jay - 28 Oct 2005 08:51 GMT
Thanks everyone for your answers,
Jay