help with IF THEN

D

doc

What is the correct syntax to write a statement that, in english, does
this

If cell L4 = 0 Then delete cells K4 through M4 and shift the cells up

Better yet can something be written that checks all L cells for the 0
value and if it finds 0 then deletes the adjacent K through M cells and
shifts all cells up

TIA
 
Top