View Single Post
 
Old 05-05-2020, 11:40 AM
gedinfo2020 gedinfo2020 is offline Windows 10 Office 2019
Novice
 
Join Date: Feb 2020
Posts: 4
gedinfo2020 is on a distinguished road
Default How do I determine rows in a table that has verticle merged cells?

I am encountering an issue in that I can not use the "normal" way of determining rows in a table, and having to use the Range object. I get the total rows in the table, using Range.Rows.Count.

My VBA code goes through each cell in the row, from top to bottom.
The main columns that I trigger off of are Column 1 and Column 4. Column 1 is the merged cell, and when I loop through, I can not seem to find a way to have the Range object tell me the current row that I am on.

I need to determine the row because there is text in Column 3 that does not show up via the direct Word search and Range.Text(It is set as either RTableHeader, RHeading2 in the Styles menu)., and am using VBA to regenerate the text in this column.

I am actually extracting some of this data for comparison purposes.

Does anyone have any ideas, or need further clarification?

Thank you.
Reply With Quote