Seamus2626
asked on
Vlookup error
Hi,
Im getting a syntax error on the below lookup i have created
Can anyone advise why this is so?
Thanks
Seamus
Function test()
Dim Res As Variant
Dim r As Long
r = ActiveCell
Res = Application.WorksheetFunct ion.VLooku p(r,Phoeni x Pivot!',A:A,1, 0)
End Function
Im getting a syntax error on the below lookup i have created
Can anyone advise why this is so?
Thanks
Seamus
Function test()
Dim Res As Variant
Dim r As Long
r = ActiveCell
Res = Application.WorksheetFunct
End Function
ASKER
Still getting a Syntax error
Seamus
Function test()
Dim Res As Variant
Dim r As Long
r = ActiveCell
Res = Application.WorksheetFunct ion.VLooku p(r,'Phoen ix Pivot'!A:A,1, 0)
End Function
Seamus
Function test()
Dim Res As Variant
Dim r As Long
r = ActiveCell
Res = Application.WorksheetFunct
End Function
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The bit A:A,1 will generate an error. Normally you would have a cell reference, e.g: A1:A10.
ASKER
Thats the one,
Thanks
Seamus
Thanks
Seamus
should be
'Phoenix Pivot'!A:A