Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
VBA: replace last occurrence of a string within a string
' replace only the LAST occurrence of a the SEARCH substring in SOURCE
' with the REPLACESTR string - search isn't case-sensitive
ReplaceLast = StrReverse(Replace(StrReverse(Source), StrReverse(Search), StrReverse(ReplaceStr), , 1))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment