Thread: Deleting empty rows if specific cell in row is empty

Hi everyone,

i have this line of code

Delete blank rows
Sub deleteblankrows()
Application.ScreenUpdating = True
[c:c].AutoFilter Field:=1, Criteria1:="="
[c2:c65536].SpecialCells(xlVisible).EntireRow.Delete
If [c1] = "" Or [d2] = "" Then [1:1].Delete
ActiveSheet.AutoFilterMode = False
Application.ScreenUpdating = True


End Sub

originally it only deletes the row if cells in column C are empty. However, i want it to delete the row if cells in column d are empty. so i nested the Or [d2] in the If statement. do i have to make changes to the other lines too?

Thanks!