Thanks for the quick reply...

Yes. The sheets are names sheet1 & sheet2.

It works fine if i change the statement :
-CompareWorksheets ActiveWorkbook.Worksheets("Sheet1"),
Workbooks("c1.xls").Worksheets("Sheet2")-
to

-'CompareWorksheets ActiveWorkbook.Worksheets("Sheet1"),
ActiveWorkbook.Worksheets("Sheet2")-

But this way I will be comparing sheets in the same workbook & not the
different ones.

Thanks in advance...
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