Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This code deletes the row, if the cell in column C IS empty.
Sub SletBlank() On Error Resume Next Columns("C:C").SpecialCells(xlCellTypeBlanks).Enti reRow.Delete End Sub I need it to do it, the other way around. Delete all rows, where the cell in column C IS NOT empty. But there is no xlCellType for "Nonblank". So how do I best do what I want. Jan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting empty rows | New Users to Excel | |||
deleting empty rows | Excel Discussion (Misc queries) | |||
Deleting All Empty Rows | Excel Discussion (Misc queries) | |||
Deleting unwanted and empty rows.... | New Users to Excel | |||
Deleting empty rows | Excel Programming |