Application.WorksheetFunction.VLookup & activecell

[d34n0]

I have a macro using "Application.WorksheetFunction.VLookup" to check a cell range for a specific value. When it finds the value i want this cell to become the activecell so i can change it. I cant seem to make it activecell

Any sugestions much appreciated.

 

[Jon von der Heyden]

What is your Vlookup? Are you just looking for a single value in a range and then want to select that cell? If so use the Find method, e.g.:

ActiveSheet.Range("A1:A100").Find("Test", , , xlWhole).Select

 

[d34n0]

That works

Thank you for your help.