This worked perfectly.
Thank you forum!
![]()
Sub Macro1() Set rng = ActiveSheet.UsedRange With rng rng.Replace What:="(", Replacement:="", LookAt:=xlPart rng.Replace What:=")", Replacement:="", LookAt:=xlPart End With End Sub
This worked perfectly.
Thank you forum!
![]()
Sub Macro1() Set rng = ActiveSheet.UsedRange With rng rng.Replace What:="(", Replacement:="", LookAt:=xlPart rng.Replace What:=")", Replacement:="", LookAt:=xlPart End With End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks