Compare two worksheets using VBA in Microsoft Excel

B

Break80

I found and ran the code contained on the Joseph Rubin's ExcelTip.com
website. The tip is called "Compare two worksheets using VBA in
Microsoft Excel" and contains all the code. Buton running the code, I
had a problem. I fails to compile on execution on the record ...
Workbooks("workbook.xls").Worksheets("sheet") record. Error is
"subscript out of range." Not being an expert at this, I don't know
how to fix it. Anyone know how to fix this? Please email me as I am
in a big hurry to do this compare if you know what the issue
is...thanks.
 
T

Tom Ogilvy

Replace Workbook.xls with the name of one of the workbooks and Sheet with
the name of the Sheet in that workbook.

I assume you will need to make a similar correction for the sheet being
compared to.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare two workbooks and hi-light matches 0
Excel file compare (each sheet). Is there something already available?. 2
Compare two worksheets in the same workbook and highlight difference 7
Advanced compare of two worksheets 2
Compare two columns in a different worksheet 3
Comparing two workbooks - Excel 2010 - not using Add-ins 2
compare contents of two folders 8
Excel VBA help: Text file formatting 19

Top