Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare two worksheets using VBA in Microsoft Excel
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. -- Break80 ------------------------------------------------------------------------ Break80's Profile: http://www.excelforum.com/member.php...o&userid=15277 View this thread: http://www.excelforum.com/showthread...hreadid=269002 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare two worksheets using VBA in Microsoft Excel
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. -- Regards, Tom Ogilvy "Break80" wrote in message ... 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. -- Break80 ------------------------------------------------------------------------ Break80's Profile: http://www.excelforum.com/member.php...o&userid=15277 View this thread: http://www.excelforum.com/showthread...hreadid=269002 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA. Compare 2 worksheets. | Excel Worksheet Functions | |||
Relative referencing in Microsoft Excel between worksheets | Excel Discussion (Misc queries) | |||
Can I compare two worksheets using Excel? | Excel Worksheet Functions | |||
Compare 2 similar excel worksheets | Excel Worksheet Functions | |||
How to file compare Excel worksheets | New Users to Excel |