Compare two worksheets using VBA in Microsoft Excel
 

That is what I did when I had the problem

--
Break8
-----------------------------------------------------------------------
Break80's Profile: http://www.excelforum.com/member.php...fo&userid=1527
View this thread: http://www.excelforum.com/showthread.php?threadid=26900

Compare two worksheets using VBA in Microsoft Excel
 

Workbooks("workbook.xls").Worksheets("sheet") record. Error is
"subscript out of range."

the error means
workbook.xls doesn't exist
or
sheet doesn't exist.

If you have a workbook named workbook.xls and it contains a sheet named
sheet and it is open in excel, then you wouldn't get the error. (this
statement is based on what you have told us).

--
Regards,
Tom Ogilvy

"Break80" wrote in message
...

That is what I did when I had the problem.


--
Break80
------------------------------------------------------------------------
Break80's Profile:
http://www.excelforum.com/member.php...o&userid=15277
View this thread: http://www.excelforum.com/showthread...hreadid=269002