Hi,
I know I could use a loop or FindNext to achieve this but wondering if there is anyway to do it in a one liner by modifying the below (or another way)
Obviously the below does exactly what I want if the replacement were required in ColB but is there anyway to offset the 'Replacement' to ColC
Basically if the value WF appears anywhere in colB then change the value of ColC to 0.
I know I could use a loop or FindNext to achieve this but wondering if there is anyway to do it in a one liner by modifying the below (or another way)
Obviously the below does exactly what I want if the replacement were required in ColB but is there anyway to offset the 'Replacement' to ColC
VBA Code:
Range("B:B").Replace What:="*WF", Replacement:="0", LookAt:=xlWhole
Basically if the value WF appears anywhere in colB then change the value of ColC to 0.