Skip to content

Instantly share code, notes, and snippets.

@ndthanh
Forked from spiridenok/gist:6154707
Created August 26, 2021 17:38
Show Gist options
  • Save ndthanh/015198bd57d2fa278fb0df033d72b844 to your computer and use it in GitHub Desktop.
Save ndthanh/015198bd57d2fa278fb0df033d72b844 to your computer and use it in GitHub Desktop.
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