Replace Workbook.xls with the name of one of the workbooks and Sheet with
the name of the Sheet in that workbook.

I assume you will need to make a similar correction for the sheet being
compared to.
--
Regards,
Tom Ogilvy


"Break80" wrote in message
...

I found and ran the code contained on the Joseph Rubin's ExcelTip.com
website. The tip is called "Compare two worksheets using VBA in
Microsoft Excel" and contains all the code. Buton running the code, I
had a problem. I fails to compile on execution on the record ...
Workbooks("workbook.xls").Worksheets("sheet") record. Error is
"subscript out of range." Not being an expert at this, I don't know
how to fix it. Anyone know how to fix this? Please email me as I am
in a big hurry to do this compare if you know what the issue
is...thanks.


--
Break80
------------------------------------------------------------------------
Break80's Profile:
http://www.excelforum.com/member.php...o&userid=15277
View this thread: http://www.excelforum.com/showthread...hreadid=269002