• Home
 · 
• String Manipulation
 · 
• Function to find the last occurrence of one string within another

Function to find the last occurrence of one string within another

Function to find the last occurrence of one string within another

Rate Function to find the last occurrence of one string within another

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

    
    Dim P As Long, LastP As Long, Start As Long
    
    P = InStr(1, sTarget, sFind, iCompare)
    Do While P
        LastP = P
        P = InStr(LastP + 1, sTarget, sFind, iCompare)
    Loop
    InStrR = LastP
    
End Function