VBA does not know what Table means. You have to tell it that it is a Range.
Cells(2, 9) = WorksheetFunction.VLookup(Cells(2, 7), Range(Table), 2, 0)

Be careful of which sheet these Cells/Range objects are pointing to.

NickHK

"T De Villiers"
wrote in message
news:T.De.Villiers.2butf0_1154423705.0108@excelfor um-nospam.com...

Table is a name I have defined,
the following is my vlookup with which I get object-defined error,

many Thanks

Sub test()

Cells(2, 9) = WorksheetFunction.VLookup(Cells(2, 7), Table, 2, 0)


End Sub


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile:
http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=566961