If ActiveCell.Offset(0, 17) = "Closed" Then activecell.EntireRow.Delete


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Albert" wrote in message
...
Hi Guys,

I would like to delete the row if a column "status" changes to "closed.

this is what I got, but of course it is not working can you help?

Dim cnclrge As Range
' If ActiveCell.Offset(0, 17) = "Closed" Then
'
' cnclrge.EntireRow.Delete
' End If

Thanks
Albert