Ok... I think I know the answer... after many time I had tried!!!
:)

Cells(NextRow, 9) = "=VLOOKUP(RangeName,Rlookup,3,FALSE)"

Juz insert the vlookup function like this in my vba code... and I go
it! :

--
Message posted from http://www.ExcelForum.com