VBA macro to delete row if cell in Column A is empty

[XcelNoobster]

How would I create a macro that loops through the current open sheet and deletes the current row if the cell in Column A is Empty?

 

[Micron]

Using a counter to loop over a used range on the active sheet is a very common topic. Did you look for any code to do that? You could start with what you find, edit it to suit your case and post what you tried if not successful. Then people would have something to work with.

 

[jolivanes]

Why loop?

Sub No_Loop()
    Columns(1).SpecialCells(4).EntireRow.Delete
End Sub

 

[Micron]

Fair point. Still learning, I guess.

 

[jolivanes]

No problem. We all are, whether we admit it or not.

 

[jolivanes]

​

XcelNoobster is not happy with the suggestions because we have not heard anything back.