Hi
I please need help with the following issue I am experiencing
I want to replace a "." character in the value of the cell to "-" using VBA code
I currently have the following code
Sub ReplaceInSelection()
Selection.Find(What:=".", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate
Selection.Replace What:=".", Replacement:="-", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub
Will this work and how do I apply/call it on a cell value?
Please advise me on this
Thank you
Bookmarks