Deleting a row as a condition of a formula.
 

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?

Deleting a row as a condition of a formula.
 

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


"Darryl M." <Darryl wrote in message
...
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?

Deleting a row as a condition of a formula.
 

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

"Darryl M." wrote:

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?