N
NFL
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
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