Hello,




I'm looking for some assistance with a issue I'm having using VBA.

I have a Table (2 Columns and hundreds of Rows) and I want to Compare the individual words in each Row (Column #1 of Row #1) against the individual words in (Column #2 of Row #1) and if there are "Duplicate Words in each Column (Capitalization does not matter) I want the words "Highlighted". Each successive Row will be compared against that Row's 2 Columns only.

please see attachment sample table graphic.

Any help would be greatly appreciated.

Keith

Attached Images

sample-table.jpg (221.2 KB, 25 views)