Hi
how is ly defined?

--
Regards
Frank Kabel
Frankfurt, Germany

"Jill" schrieb im Newsbeitrag
...
Hi Frank
Tried your suggestion this returns a 'type mismatch' error
any other suggestions.
thanks Jill
-----Original Message-----
Hi
try:
Ix = application.evaluate("=VLookup(c21, 'C:\Documents and
Settings\Jill\My
Documents\[EmailNames.xls]sheet1'!a1:b20, 2, 0)")

--
Regards
Frank Kabel
Frankfurt, Germany

"Jill" schrieb im
Newsbeitrag
...
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

.