I am looking for a macro that delete a row if cell in column B is empty.
Thank you.
I am looking for a macro that delete a row if cell in column B is empty.
Thank you.
Greetings KillBill,
I see that you just joined vbaexpress :-) Welcome here!
For your current issue, try SpecialCells...
PLease note that I used code within the Worksheet's module; thus - the Me keyword. Presuming your code is within a Standard Module, you will want to set an explicit reference to the range differently. As long as the sheet is going to remain in existence, I would suggest the sheet's CodeName.Option Explicit Sub exampple() Me.Range("B:B").SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub
Hope that helps,
Mark