Change a field and delete row
Thanks guys, sorted.
"FSt1" wrote:
hi
your not setting the active cell to equal cnclrge.
Dim cnclrge As Range
set cnclrge = activecell
If ActiveCell.Offset(0, 17) = "Closed" Then
cnclrge.EntireRow.Delete
'or Activecell.EntireEow.Delete
end if
Personally i dislike using Activecell and perfer using variables but
everyone has your own way.
Regards
FSt1
"Albert" wrote:
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
|