This macro requires that c1.xls be open, too.

Is it?

And are you sure you have the correct name--it's c1.xls. That second character
is a 1 (one), not an L (ell).

And are you sure that there is a worksheet named Sheet1 in the activeworkbook
and a worksheet named Sheet2 in that c1.xls workbook?

JAtz_DA_WAY wrote:

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

--

Dave Peterson