Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB error '1004' Unable to get VLookup property to work right
Try the below...Declared as variant,
Sub Macro() Dim Location As Variant ' number used to look for city Location = 1 Worksheets("Master").Activate With ActiveSheet ..Range("V3") = Application.WorksheetFunction.VLookup(Location, _ Sheets("City").Range("A2:B3"), 2, False) End With End Sub If this post helps click Yes --------------- Jacob Skaria "NFL" wrote: I'm getting a run-time error 1004 and don't know what is missing. I have 2 columns in the City worksheet as shown below. Thank you! A B Location City 1 Springfield 2 Dallas 3 etc. etc.. I want the Master worksheet to look for a city/town in the City worksheet and place that value in V3. dim Location as string ' number used to look for city Worksheets("Master").Activate With ActiveSheet .Range("V3") = Application.WorksheetFunction.VLookup(Location, Sheets("City").Range("A2:B3"), 2, False) End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error 1004 Unable to set the top property of the picture c | Excel Discussion (Misc queries) | |||
Error 1004 - unable to set the FormulaArray property of the Range | Excel Programming | |||
Error 1004: Unable to get the axis property | Charts and Charting in Excel | |||
Run Time Error 1004 Unable to set hidden property | Excel Programming | |||
Run-time Error '1004' Unable to get the findnext property... | Excel Programming |