Deleting a row as a condition of a formula.

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

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

FSt1

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