| 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 |
| 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) | |||
Threaded Mode
