Mattie Owens
asked on
Compare 2 Columns in Word Table
I am comparing column 4 to column 39. in table 7. Is there a easier way. It works, but seems to much. I have to compare about 30 columns to 39 , and would have to copy all each time. I think I asked before but can't find my question.
If tbl7.Cell(3, 4).Range.Text = tbl7.Cell(3, 39).Range.Text And _
tbl7.Cell(4, 4).Range.Text = tbl7.Cell(4, 39).Range.Text And _
tbl7.Cell(5, 4).Range.Text = tbl7.Cell(5, 39).Range.Text And _
tbl7.Cell(6, 4).Range.Text = tbl7.Cell(6, 39).Range.Text And _
tbl7.Cell(7, 4).Range.Text = tbl7.Cell(7, 39).Range.Text And _
tbl7.Cell(8, 4).Range.Text = tbl7.Cell(8, 39).Range.Text And _
tbl7.Cell(9, 4).Range.Text = tbl7.Cell(9, 39).Range.Text And _
tbl7.Cell(10, 4).Range.Text = tbl7.Cell(10, 39).Range.Text And _
tbl7.Cell(11, 4).Range.Text = tbl7.Cell(11, 39).Range.Text And _
tbl7.Cell(12, 4).Range.Text = tbl7.Cell(12, 39).Range.Text And _
tbl7.Cell(13, 4).Range.Text = tbl7.Cell(13, 39).Range.Text Then
If tbl7.Cell(3, 4).Range.Text = tbl7.Cell(3, 39).Range.Text And _
tbl7.Cell(4, 4).Range.Text = tbl7.Cell(4, 39).Range.Text And _
tbl7.Cell(5, 4).Range.Text = tbl7.Cell(5, 39).Range.Text And _
tbl7.Cell(6, 4).Range.Text = tbl7.Cell(6, 39).Range.Text And _
tbl7.Cell(7, 4).Range.Text = tbl7.Cell(7, 39).Range.Text And _
tbl7.Cell(8, 4).Range.Text = tbl7.Cell(8, 39).Range.Text And _
tbl7.Cell(9, 4).Range.Text = tbl7.Cell(9, 39).Range.Text And _
tbl7.Cell(10, 4).Range.Text = tbl7.Cell(10, 39).Range.Text And _
tbl7.Cell(11, 4).Range.Text = tbl7.Cell(11, 39).Range.Text And _
tbl7.Cell(12, 4).Range.Text = tbl7.Cell(12, 39).Range.Text And _
tbl7.Cell(13, 4).Range.Text = tbl7.Cell(13, 39).Range.Text Then
Is this a continuation of https://www.experts-exchange.com/questions/29152094/compare-2-columns-in-word-table-for-match.html or a different issue?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.