Deleting rows based on criteria

[John Walker]

Hi,
Does anyone know the way to write a Macro which will
delete all rows where column M is empty?

Thanks,
John

 

[Jim Rech]

Range("M:M").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

 

[Guest]

Worked great! Thanks!