Thread: how do I delete a row automatically after each date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
galimi galimi is offline
external usenet poster
  
Posts: 210
Default how do I delete a row automatically after each date
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
Reply With QuoteReply With Quote