add in the parameters to the Find function to only find an exact match.

**jakeembx** · 01-07-2014, 08:47 AM

Hi!

Does anyone know how to add in the parameters to the Find function to only find an exact match.

**cytop** · 01-07-2014, 08:54 AM

Duplicate post: http://www.excelforum.com/excel-prog...ction-vba.html

**Rem0ram** · 01-07-2014, 08:56 AM

in the find and replace window Click the Options button which unveil additional options where select the Match entire cell contents option.

Incase if you want the programatic result use the below...

Please Login or Register  to view this content.

Changing the LookAt:= option in the code to xlPart will search partial text where as xlWhole find exact match.

**Fotis1991** · 01-07-2014, 08:57 AM

Thanks cytop

Unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.