Application.WorksheetFunction.VLookup & activecell

d34n0

Board Regular
Joined
Jun 28, 2004
Messages
121
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.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,801
Office Version
  1. 365
Platform
  1. Windows
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.:

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

Watch MrExcel Video

Forum statistics

Threads
1,108,991
Messages
5,526,105
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top