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