Hi All,

I was trying to execute the macro on the link:
http://www.exceltip.com/st/Compare_t...ce 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


--
JAtz_DA_WAY
------------------------------------------------------------------------
JAtz_DA_WAY's Profile: http://www.excelforum.com/member.php...o&userid=26684
View this thread: http://www.excelforum.com/showthread...hreadid=399567