Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to delete rows based on date
I have a spreadsheet with completion dates in column C. I want my macro to
look at each date, check to see if it's older than 30 days, and then delete the rows that are older than 30 days. I have a macro that seems to work, but I can't get it to loop (and I tried many times to make that happen). I'm missing the loop piece, but also want to make sure I've put the "formula" part in properly. Here's my macro: Public Sub Delete1() Range("c3").Select If ActiveCell.Value <= "TODAY()-30" Then ActiveCell.EntireRow.Delete Else ActiveCell.Offset(1, 0).Select End If End Sub Thanks, PMO |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Rows based on value | Excel Worksheet Functions | |||
Delete Rows Based on Words | Excel Discussion (Misc queries) | |||
Macro to delete rows based on a condition | Excel Worksheet Functions | |||
Delete rows based on criteria | Excel Discussion (Misc queries) | |||
Delete rows based on certain criteria | Excel Discussion (Misc queries) |