Range.AutoComplete (Excel)

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.

This method works even if the AutoComplete feature is disabled.

AutoComplete (String)

String: The string to complete.

Dim strString As String: strString = 
Dim strAutoComplete As String
strAutoComplete = ActiveCell.AutoComplete(String:=strString)