here is an example
A B C
1 12/20/06 Bill 6am to 2pm Tom 2pm to 10 pm
2 12/21/06 Dan 6am to 2pm carl 2pm to 10 pm
3 12/20/06 Bill 6am to 2pm Tom 2pm to 10 pm
4 12/21/06 Dan 6am to 2pm carl 2pm to 10 pm


when 12/20 is over I want row 1 to be deleted

Sorry about being a pain but thanks for your help


"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