Hi,
I am trying to revise part of string in excel,
but my code cannot produce my expectation.
Hope somebody can help.
Sub FindSplitReplace()
Dim sht As Worksheet
Dim wb As Workbook
Dim strBD As String
Dim arrSplitformat() As String
Dim rmkrng As Range
Dim Usedrng As Range
Dim Usedrmkrng As...