So, are saying , everything in that row will be deleted after that date?

"galimi" wrote:

I have copied an example to http://HelpExcel.com/examples

--
http://HelpExcel.com




"delete automatically" wrote:

Where do I copy it too?
Thanks for your help

"galimi" wrote:

You can embed code similar to the following on an selection change event for
the sheet

For Each cl In ActiveSheet.UsedRange.Cells

If cl.Value < Now Then

ActiveSheet.Rows(cl.Row).Delete

End If

Next
--
http://HelpExcel.com




"delete automatically" wrote:

how do I delete a row automatically after each date is over