![]() |
#6
|
|||
|
|||
![]()
.
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). |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Phil H | Excel | 3 | 11-05-2018 12:09 PM |
![]() |
Greengecko | Word VBA | 5 | 06-14-2016 07:54 AM |
Find and Delete Rows based on a range | damaniam | Excel Programming | 2 | 03-12-2014 06:06 AM |
![]() |
Learner7 | Excel | 1 | 04-19-2011 02:45 AM |
Temporarily show/hide selected table rows | glricht | Word Tables | 0 | 12-29-2009 05:40 AM |