'方法1
Sub test()
Dim A, i
A = Range("A1").CurrentRegion
For i = 2 To UBound(A)
If A(i, 1) = "" Then
A(i, 4) = ""
A(i, 5) = ""
End If
Next
[a1].Resize(i - 1, 5) = A
End Sub
'方法2
Sub test()
Dim i, k, Rng
For i = 2 To Range("b65536").End(xlUp).Row
If Cells(i, 4).MergeCells Then
Set Rng = Range(Cells(i, 4).MergeArea.Address)
k = i + 1
i = i + Rng.Count - 1
Range(Cells(k, 4), Cells(i, 5)) = ""
End If
Next
End Sub