Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function to del rows based on cell value
I want to search a range of cells (column R). If any of the cells in column
"R" are blank/null, I want to delete the row. What is the best way to accomplish this for a wheet or a workbook? |
#2
|
|||
|
|||
One way:
Select column R. Choose Edit/Go To/Special, select blanks and click OK. Right-click one of the selected cells and choose Delete. Select Entire Row from the popup, and click OK. or, via macro: Public Sub DeleteBlankRows() On Error Resume Next Columns(18).SpecialCells(xlCellTypeBlanks).EntireR ow.Delete On Error GoTo 0 End Sub You can find many other ways in the archives: http://groups.google.com/advanced_gr...ugroup=*excel* In article , "Reed" wrote: I want to search a range of cells (column R). If any of the cells in column "R" are blank/null, I want to delete the row. What is the best way to accomplish this for a wheet or a workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Can I count in an array based on a function? | Excel Worksheet Functions | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
parse cell and insert rows? | Excel Worksheet Functions |