Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows based on criteria
Range("M:M").SpecialCells(xlCellTypeBlanks).Entire Row.Delete
-- Jim Rech Excel MVP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows based on criteria
Worked great! Thanks!
-----Original Message----- Range("M:M").SpecialCells (xlCellTypeBlanks).EntireRow.Delete -- Jim Rech Excel MVP . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting several rows with given criteria | Excel Discussion (Misc queries) | |||
Deleting Rows based on a Value | Excel Worksheet Functions | |||
Deleting rows by specified criteria for duplicates | Excel Discussion (Misc queries) | |||
Deleting Rows w/ Specific Criteria | Excel Discussion (Misc queries) | |||
Deleting/IDing Rows that Don't Meet Criteria | Excel Worksheet Functions |