D
dex
question: i recorded a macro that involves replacing the character "p"
in the part numbers after I run the macro with a nuLL string ""....but
i want the macro to replace the p only in the first index not anywhere
else in the part number: Here is part of my code.
Columns("A:A").Select
Selection.Find(What:="p", After:=ActiveCell, LookIn:=xlFormulas,
LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Activate
Selection.Replace What:="p", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Hope this helps.
in the part numbers after I run the macro with a nuLL string ""....but
i want the macro to replace the p only in the first index not anywhere
else in the part number: Here is part of my code.
Columns("A:A").Select
Selection.Find(What:="p", After:=ActiveCell, LookIn:=xlFormulas,
LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Activate
Selection.Replace What:="p", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Hope this helps.