Hi,
I've VBA code that I've obtained from recording a macro but it's a little lengthy. Could anyone enlightened me on how to reduce the codings?
I've VBA code that I've obtained from recording a macro but it's a little lengthy. Could anyone enlightened me on how to reduce the codings?
Code:
Columns("B:B").Select
Selection.Replace What:=" Boxes", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Columns("H:H").Select
Selection.Replace What:=" Net Amount: ", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Columns("I:I").Select
Selection.Replace What:=" Gross Amount: ", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("J:J").Select
Selection.Replace What:=" Currency: ", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False