Looks like your code is only checking column 18 to make the comparison.

Why don't you just download the free trial of my commercial add-in
"XL Companion". No registration is required.
It has a Match Rows feature under the "Compare Data" option.
It should do what you want. Download from the Products page at ...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
Portland, Oregon USA
(Excel Add-ins / Excel Programming)




wrote in message
Hi All,
I've, as I thought, crudely adapted the code below (created by Tom
Ogilvy) as I've got the following requirement/problem but I'm doing
something wrong as I can't get it to work for what I want.
- 2 spreadsheets (Columns A:R).
- Containing data from row 2 (row 1 is the header) through to Row1375
on Sheet1 and Row2937 on Sheet2.

I need to be able to report out whe
1) Any rows are unique within Sheet2 (don't exist in Sheet2)
2) Any rows are unique within Sheet1 (don't exist in Sheet2)

Ideally I'd like to have this reporting out to perhaps 2 different
worksheets, e.g. Sheet3 for scenario 1 and Sheet4 for scenario 2.

Has anyone got any code that would do this? Basically to explain what
happened, team had been working on a Shared Workbook and updating etc.
but something happened and they didn't realise they weren't using it
as a shared workbook in the meantime! Then somebody else was working
on it as a shared workbook so they're now both out of sync. I need to
understand where there are differences between the two to identify
these and have someone manually correct these.

Appreciate any help/pointers as always.
Thanks, Al.
-snip-