xlLookAt enumeration (Excel)

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

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