Range.AutoComplete Method

Syntax

expression.AutoComplete(String)

expression A variable that represents a Range object.

Parameters

Name	Required/Optional	Data Type	Description
String	Required	String	The string to complete.

Return Value
String

Remarks

This method works even if the AutoComplete feature is disabled.

Example

This example returns the AutoComplete match for the string segment "Ap." An AutoComplete match is made if the column containing cell A5 contains a contiguous list and one of the entries in the list contains a match for the string.

Visual Basic for Applications
`s = Worksheets(1).Range("A5").AutoComplete("Ap") If Len(s) > 0 Then MsgBox "Completes to " & s Else MsgBox "Has no completion" End If`

Auto complete Auto Complete Method autocomplete AutoComplete Method Built-in function for determining if I've used a certain string in a list before? Function for automatically completing a data entry? Is there a match Return an autocomplete match from the list? using autocomplete for a specific string?

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.

See also: