Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do I get VLookup error 1004
After defining a new Name ("_year") in my worksheet, I find that my makro
code (Private Sub cmdNewEntry744_Click() With NewEntries ..Show End With End Sub) can no longer open my dialog box. I get a runtime error 1004 a message refering to VLookup property of Workbook function class. The name "_year" refers to "=If(month="JAN.";R[-1]C + 1; R[-1]C)". WhatIdo?? KenG |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do I get VLookup error 1004
"KenG" wrote:
After defining a new Name ("_year") in my worksheet, [....] I get a runtime error 1004 a message refering to VLookup property of Workbook function class. The name "_year" refers to "=If(month="JAN.";R[-1]C + 1; R[-1]C)". I presume you mean WorksheetFunction.VLookup. It is unclear exactly how you are trying to refer to the Excel defined name. You should show us a code snippet. But in any case, I can imagine that WorksheetFunction.VLookup cannot reference an Excel defined name. I would use the Evaluate function. I cannot be more specific because you were not more specific. ----- original message ----- "KenG" wrote in message ... After defining a new Name ("_year") in my worksheet, I find that my makro code (Private Sub cmdNewEntry744_Click() With NewEntries .Show End With End Sub) can no longer open my dialog box. I get a runtime error 1004 a message refering to VLookup property of Workbook function class. The name "_year" refers to "=If(month="JAN.";R[-1]C + 1; R[-1]C)". WhatIdo?? KenG |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do I get VLookup error 1004
As ALWAYS, post YOUR code for comments.
-- Don Guillett Microsoft MVP Excel SalesAid Software "KenG" wrote in message ... After defining a new Name ("_year") in my worksheet, I find that my makro code (Private Sub cmdNewEntry744_Click() With NewEntries .Show End With End Sub) can no longer open my dialog box. I get a runtime error 1004 a message refering to VLookup property of Workbook function class. The name "_year" refers to "=If(month="JAN.";R[-1]C + 1; R[-1]C)". WhatIdo?? KenG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error 1004 | Excel Discussion (Misc queries) | |||
Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble | 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) |