Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble
Hello,
I have a code that is looking for a Vlookup. I know that some of the queries are N/A# and to have On Error Resume Next error handling. The code is perfectly working in one computer and is generating "1004 run time error : Unable to get the Vlookup propert of the WorksheetFunction class error" in another. I have reloaded the Excel and Repaired, Diagnosed Excel, restored 2-3 days before from the backup. None yielded any cure. I work on XP Pro, have both 2003 & 2007 version generate the same fault. It seems as if On Error Resume is doomed. Any suggestions or perhaps remedies mostly welcomed and highly appreciated. Regards, VBA Novice. asking for "Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble
In VB Editor, compare the references (Tools-References) between the two
computers.. Pl. share the code... "VBANovice" wrote: Hello, I have a code that is looking for a Vlookup. I know that some of the queries are N/A# and to have On Error Resume Next error handling. The code is perfectly working in one computer and is generating "1004 run time error : Unable to get the Vlookup propert of the WorksheetFunction class error" in another. I have reloaded the Excel and Repaired, Diagnosed Excel, restored 2-3 days before from the backup. None yielded any cure. I work on XP Pro, have both 2003 & 2007 version generate the same fault. It seems as if On Error Resume is doomed. Any suggestions or perhaps remedies mostly welcomed and highly appreciated. Regards, VBA Novice. asking for "Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble
Check your other post.
VBANovice wrote: Hello, I have a code that is looking for a Vlookup. I know that some of the queries are N/A# and to have On Error Resume Next error handling. The code is perfectly working in one computer and is generating "1004 run time error : Unable to get the Vlookup propert of the WorksheetFunction class error" in another. I have reloaded the Excel and Repaired, Diagnosed Excel, restored 2-3 days before from the backup. None yielded any cure. I work on XP Pro, have both 2003 & 2007 version generate the same fault. It seems as if On Error Resume is doomed. Any suggestions or perhaps remedies mostly welcomed and highly appreciated. Regards, VBA Novice. asking for "Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble" -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
Macro code error; machine dependent | Excel Worksheet Functions | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |