Hi All,
I'm new here. In advance, already thanks for helping/thinking with me :-).
Situation:
- I've a sheet with data input.
- I've a validation button.
- I've a sheet with valid information (containing company names).
- I've a sheet with validated information (output).
My problem is the following:
I put information on the data input sheet, after the validation button, it comes up with the wrong company name.
Example:
There's a company called BN, but after pressing the validation button, the VBA checks the sheet with valid information and finds ABN as the first option and stops looking for BN, then ABN (instead of BN) gets put on the validated information sheet.
I would like:
Check the whole cell/whole text (has to match entirely) instead of find the first.
The current code:
Set lookup = Sheets(SHEET_CP_NAME).Range("CP_name")
I think it would be something like this, but unfortunately that doesn't work:
Set lookup = Sheets(SHEET_CP_NAME).Range("CP_name").Find(LookAt:=xlWhole)
Thanks again for your help and effort.
Bookmarks