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