error message in Vlookup
Anyone know why the following code returns 'sub or
function not defined' and highlights Vlookup, am I missing
a reference?
Thanks for any help.
Dim Ix As String
Ix = VLookup(c21, "C:\Documents and Settings\Jill\My
Documents\[EmailNames.xls]sheet1!a1:b20", 2, False)
MsgBox Ix
End Sub
|