Deleting a row as a condition of a formula.

  • Thread starter Thread starter Darryl M.
  • Start date Start date
D

Darryl M.

Is there a way to create a formula that looks at a cell and if that cell is
"False" the result is the deletion of a defined row within an Excel sheet?
 
Sub DeleteRow()
If Sheet1.Range("A1").Value = "False" Then ' Change cell to suit
Rows("9:9").Select ' Change row to suit
Selection.Delete Shift:=xlUp
End If
End Sub


Corey....
 
hi.
no. formulas return values to the cell which they occupy. they cannot
perform actions like delete row.
sorry.
regards
FSt1
 
Back
Top