Range.AutoComplete Method

Returns an AutoComplete match from the list.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function AutoComplete ( _
    String As String _
) As String
'Usage
Dim instance As Range
Dim String As String
Dim returnValue As String

returnValue = instance.AutoComplete(String)

string AutoComplete(
    string String
)

Parameters

• String
  Type: System.String

  Required String. The string to complete.

Return Value

Type: System.String

Remarks

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.

This method works even if the AutoComplete feature is disabled.

See Also

Reference

Range Interface

Range Members

Microsoft.Office.Interop.Excel Namespace