Using Find to locate data.

[Jietoh]

Greetings all,

I wrote the following script to find an entry in a long list based on two values found in cells V12 & W12. Essentially, W12 contains either "Last Name", or "First Name", while V12 contains the actual text that needs to be found. Based on the entry in W12 it'll select a different column to search for a match to the V12 data. When I tested this code, it works fine when searching for "First Name", but constantly fails to find any match when searching for "Last Name". There is no error code, it simply fails to find any match, valid or not.

Please Login or Register  to view this content.

Thanks in advance.

[davesexcel]

Probably, this is the problem

Change
Range(ActiveCell.Offset(0, 5)).Select
to

Please Login or Register  to view this content.

[davesexcel]

This seems to work as well,

Please Login or Register  to view this content.

[Jietoh]

Thanks! Such a simple error.