range method with multiple columns & i

[jamada]

Hi there, the following code almost works, however it does not remove the middle range as desired, any suggestions!



"B" & i works ok
"O" & i works ok

"L" & i DOES NOT WORK


Dim i As Long
For i = Lastrow To 3 Step -1

If Cells(i, 1).Value > 0 Then
Range("B" & i & ",L" & i & ",O" & i).Replace What:="ZX ", Replacement:="", LookAt:=xlPart, SearchOrder:= _
xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False

End If
Next

Thanks Graham

 

[Fluff]

It works for me. What is the value in col L when it doesn't work?

 

[jamada]

Fluff... that's all it took, you pointed me in the right direction!

I was certain I was miscoding this, so much so I over looked what the value was in "L".
"B" & "O" had "ZX_", whereas "L" had "ZX" with no space!!!

Thank you for your help again!

Graham

 

[Fluff]

Glad to help & thanks for the feedback