Hi All,

I was trying to execute the macro on the link: http://www.exceltip.com/st/Compare_...xce l/477.html

But I get the error: "Run time error 9 : Subscript out of range" when I try to compare 2 workbooks.

The line where i get error is:

CompareWorksheets ActiveWorkbook.Worksheets("Sheet1"), _
Workbooks("WorkBookName.xls").Worksheets("Sheet2")

I even tried renaming the file on my system to workbookname.xls.....but it just doeesnt work.

Please advise...

Regards,

Jatz