|
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 |
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 |
| All times are GMT +1. The time now is 08:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com