AutoComplete Method

         Example         Applies To

Returns an AutoComplete match from the list. If there’s no AutoComplete match or if more than one entry in the list matches the string to complete, this method returns an empty string.

Syntax

expression.AutoComplete(String)

expression   Required. An expression that returns a Range object (must be a single cell).

String   Required String. The string to complete.

Remarks

This method works even if the AutoComplete feature is disabled.