XlLookAt Enumeration

Specifies whether a match is made against the whole of the search text or any part of the search text.

Version Information
 Version Added:  Excel 2007

Name Value Description
xlPart 2 Match against any part of the search text.
xlWhole 1 Match against the whole of the search text.