InStrRev Function

Syntax:

InStrRev(S1$, S2$[, Index])

Group:

String

Description:

Return the index where S2$ last matches S1$. If no match is found, 0 is returned.

 

Parameter

Description

S1$

Search for S2$ in this string value. If this value is Null then Null is returned.

S2$

Search S1$ for this string value. If this value is Null then Null is returned.

Index

Start searching for S2$ ending at this index in S1$. If this is omitted then start searching from the end of S1$.

 

See Also:

Left$( ), Len( ), Mid$( ), Replace$( ), Right$( ).

Example:


Sub Main
  Debug.Print InStrRev("Hello","l") ' 4
End
Sub