XlLookAt Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

Show: