Error in http://www.exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Exc

[JAtz_DA_WAY]

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

[Tom Ogilvy]

This would mean that you are trying to reference a sheet or workbook which
does not exist.

--
Regards,
Tom Ogilvy


"JAtz_DA_WAY" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
>
> --
> 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=399592
>

[JAtz_DA_WAY]

But the problem is that the file exists & with the exactly same name....

[JAtz_DA_WAY]

And also in the same directory !!

[Dave Peterson]

You have one more guess at your post in .misc.



JAtz_DA_WAY wrote:
>
> And also in the same directory !!
>
> --
> 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=399592

--

Dave Peterson