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
Bookmarks