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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.