Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error 424
I am very new to VB and I'm sure there must be an easier
way to do what I want. I am trying to take a value from a text box on a form and move it to a cell in my worksheet. The location of the cell is determined by a VLOOKUP function. When I run the following code I get a run-time error 424: Object Required. The error occurs on the last ine. Any ideas on what may be missing? Thanks for any help. Set CurrentDealer = Worksheets("All Dealers Data").Range("A74:a74") Set DealerData = Worksheets("All Dealers Data").Range ("A2:aa72") Application.WorksheetFunction.VLookup(CurrentDeale r, DealerData, 24, False) = txtAltGoal.Value |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error 424
If the expression
Application.WorksheetFunction.VLookup(CurrentDeale r, _ DealerData, 24, False) = txtAltGoal.Value returns a cell address like A1 then you need to change it to Range(Application.WorksheetFunction.VLookup(Curren tDealer, _ DealerData, 24, False)) = txtAltGoal.Value HTH, Shockley "Dale" wrote in message ... I am very new to VB and I'm sure there must be an easier way to do what I want. I am trying to take a value from a text box on a form and move it to a cell in my worksheet. The location of the cell is determined by a VLOOKUP function. When I run the following code I get a run-time error 424: Object Required. The error occurs on the last ine. Any ideas on what may be missing? Thanks for any help. Set CurrentDealer = Worksheets("All Dealers Data").Range("A74:a74") Set DealerData = Worksheets("All Dealers Data").Range ("A2:aa72") Application.WorksheetFunction.VLookup(CurrentDeale r, DealerData, 24, False) = txtAltGoal.Value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Receiving run-time error only part of the time | Excel Discussion (Misc queries) | |||
run-time error '91'-Close Button error | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel |