For range of ascending order, find the hypothetical row address for new String

[Un-Do Re-Do]

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

[jindon]

Have you tried Match with 1 in 3rd arg?
e.g

Please Login or Register  to view this content.

[Un-Do Re-Do]

OK thanks.
This does work.
The fault was mine, the "1" option does require sorting in ascending order, but my sorting procedure was the issue.