View Single Post
 
Old 11-18-2018, 11:36 AM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
The first macro I posted will hide the selected rows. It will not delete those rows.

The second two macros posted both do the same thing - delete the rows selected. EXCEPT, "Selection.EntireRow.Delete" deletes rows period. There is no qualification such as an empty cell ... the macro just deletes any row that is selected.

The other "Columns("C:C").SpecialCells(xlCellTypeBlanks).Ent ireRow.Delete" looks at the entire sheet automatically (no need to select any row/s), determines if there is a blank cell in the C column ... and if found, deletes that row.

"Selection" is the same as you clicking on a row number (on the left side of the sheet).
Reply With Quote