Delete left cell based on right cell value

[mpfx]

Hi all,

I need a macro to delete the values in L3 if the cell value in M3 = 0

I need to do this from L3 to L80 using corresponding cells in col M3 to L80

Thanks for any help.

 

[VoG]

Try

Sub test()
Dim i As Long
For i = 3 To 80
    If Range("M" & i).Value = 0 Then Range("L" & i).ClearContents
Next i
End Sub

 

[mpfx]

Wow, many thanks for quick reply.

Works perfectly...

Again Thanks...