Please, please, do at least one Google search before asking for help. My
Google search was: use worksheet functions in vba
There were many thousands of hits, and the very first one was certainly
relevant. The third hit even gave an example of calling VLookUp!!! Please
try a search yourself.