If I have an existing Excel range which is sorted in ascending order, and I want to know where a new string should go, by determining the row address.
Is there an existing function which would work?

I've tried "WorksheetFunction.Match" with wildcard characters but this only works when the new string is shorter than existing cell values.
So if I try to find the row address for new string "Exc", it will relate to the existing value of "Excel".
But if I try for "ExcelMacro", nothing.


Capture.PNG