| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| 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 | |||
| Compare two worksheets using VBA in Microsoft Excel | Excel Programming | |||
![Break80[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
