| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dget in VBA gets Object required run-time error?
This sheet function is ok:
DGET(ACDB, "TAS", $B$1:$B$2) I can not get it to work in VBA: Tas = Application.WorksheetFunction.DGet(ACDB, "TAS", Range("$B$1:$B$2").Value) I get the Run-time error 424. I have tried to explicitly specify the first and third parameter without any joy. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dget in VBA gets Object required run-time error?
try removing Value
Tas = Application.WorksheetFunction.DGet(ACDB, "TAS", Range("$B$1:$B$2")) -- Regards, Tom Ogilvy John MacGregor wrote in message om... This sheet function is ok: DGET(ACDB, "TAS", $B$1:$B$2) I can not get it to work in VBA: Tas = Application.WorksheetFunction.DGet(ACDB, "TAS", Range("$B$1:$B$2").Value) I get the Run-time error 424. I have tried to explicitly specify the first and third parameter without any joy. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
| Runtime error '424': Object Required | Excel Discussion (Misc queries) | |||
| "Microsoft Visual Basic runtime error '424' object required". | Excel Worksheet Functions | |||
| error while compiling "OBJECT REQUIRED" | Excel Discussion (Misc queries) | |||
| error 424 - Object Required | Excel Programming | |||
Linear Mode
