Galimi,

I had it working until I lost the formula you gave me. It was the one you
sent me in reply 2 something like ()+1.
could you please send it again, I must have deleted it thanks again


"galimi" wrote:

I've corrected the code and put it at

http://HelpExcel.com/examples

It's named autoDelete.xls

This will delete the entire row.
--
http://HelpExcel.com

516-984-0252


"delete automatically" wrote:

Galmini,

were almost there, I have the dates in column A row 1 I also have other
stuff in columns 2 thru 10. The date in column 1 delets but everything to
the right stays there. What I'm looking for is to delete the whole row when
that date ends.

Thanks for your patients


"galimi" wrote:

Correct. Try entering a date prior to today. You will notice that the
entire row will delete automatically.
--
http://HelpExcel.com




"delete automatically" wrote:

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