Hello Phillip,
The asterisk is a wild card character meaning any character found. The Find method of the Range object Rng, searches that range for any characters starting after the first character in the range.
The argument xlPrevious starts the search backwards from the first cell in the range row by row until it finds a cell with one or characters. The search direction can be controlled to search by columns or by rows. This is controlled by the argument xlByRows.
If the search is successful, the reference to the cell object is returned. The Row property of the range cell returns the worksheet row where the cell was found. If it fails then the special object value Nothing is returned.
Bookmarks