Deleting a row as a condition of a formula.

[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?

 

[Corey]

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....

 

[FSt1]

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