ExcelBanter - Deleting rows based on criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Deleting rows based on criteria (https://www.excelbanter.com/excel-programming/285320-deleting-rows-based-criteria.html)

John Walker[_2_]

Deleting rows based on criteria

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

Thanks,
John

Jim Rech

Deleting rows based on criteria

Range("M:M").SpecialCells(xlCellTypeBlanks).Entire Row.Delete

--
Jim Rech
Excel MVP

No Name

Deleting rows based on criteria

Worked great! Thanks!

-----Original Message-----
Range("M:M").SpecialCells
(xlCellTypeBlanks).EntireRow.Delete

--
Jim Rech
Excel MVP

.

All times are GMT +1. The time now is 07:09 AM.