Hlookup with Variable.

[Ksquared]

Hello All.
Having a go at some VBA Excel 2010, and hit a roadblock.

If asmblyCode = Application.WorksheetFunction.HLookup(asmblyCode,Sheet3!B$2:!S$3', 1, False) Then
So, im trying to do a lookup for the variable asmblyCode on sheet3 B2-S3 on the first row.
I get a list separator or ) error.

Im not sure what is causing it......
Appreciate your help.

 

[SkipVought]

hi,

If asmblyCode = Application.WorksheetFunction.HLookup(asmblyCode,[highlight]Sheets("Sheet3").Range(B$2:S$3")[/highlight], 1, False) Then

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[judgeh59]

Hi Skip

should there be a doublequote before the B$2 to match the one after the $3?

Sheets("Sheet3").Range(B$2:S$3")
^

Ernest

Be Alert, America needs more lerts

 

[SkipVought]

Sheets("Sheet3").Range([highlight]"[/highlight]B$2:S$3")

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]