VBA InStrRev Function

The Excel/VBA InStrRev function (In String Reverse), is just like the InStr function except for it searches the given term from the end of given string.

VBA Max Function

The Max() is WorksheetFunction that you may use in the VBA coding to get the maximum number.

It takes up to thirty arguments i.e.