Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2005

Tip: Looking for answers? Try searching our database.

Accessing cells in an 'uneven' table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jay - 27 Oct 2005 11:05 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.