Macro to delete row if column B is blank

[eages]

I am almost pulling out the white flag and surrendering to my evil enemy Macros.

I am hoping that there is someone out there who can help me with How to I write a macro that will check rows on a worksheet to see if Column B is blank and if found it will delete the row regardless of what data is in the other cells.

Cells range from A:L

Many thanks in advance

 

[Tom Urtis]

If blank means empty, then this would do it:

On error resume next
columns(2).specialcells(4).entirerow.delete
err.clear

 

[ravishankar]

Hi
try these codes

sub eages()
dim a as long
for a = Cells(rows.count,2).end(xlup).row to 2 step -1
if cells(a,2)= "" then
rows(a).delete
end if
next a
msgbox "Complete"
end sub

Ravi

 

[eages]

Thanks Tom I can put the white sheet away and continue my fight against macros.

This works exactly sorry I didn't explain better in regards to blank means empty.

 

[Tom Urtis]

OK, and hopefully you will regard macros as your friends fighting for you, and not an adversary fighting against you !!