| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I delete a row automatically after each date
how do I delete a row automatically after each date is over
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I delete a row automatically after each date
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I delete a row automatically after each date
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I delete a row automatically after each date
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically filling date of today (without it changing tomorrow) | Excel Discussion (Misc queries) | |||
| In Excel why does the date I enter automatically change by 1 day? | Excel Worksheet Functions | |||
| date of monday of each week automatically | Excel Discussion (Misc queries) | |||
| Excel to automatically enter a date | Excel Worksheet Functions | |||
| Automatically enter today's date as a static entry | Excel Worksheet Functions | |||
Hybrid Mode
