LinkBack URL
About LinkBacks
Hello members,
Could you please help me to "delete all rows with a date greater than" (e.g. 31/12/2010).
Data are in 3 columns and dates are in Col A.
date greater.png
Thank you
Delete all rows with a date greater than ...
Hello members,
Could you please help me to "delete all rows with a date greater than" (e.g. 31/12/2010).
Data are in 3 columns and dates are in Col A.
date greater.png
Thank you
Last edited by Moriexcel; 12-14-2014 at 10:07 AM.
It's hard to work with a picture, why not supply a sample workbooK
Try this.
Columns("A:A").AutoFilter Field:=1, Criteria1:=">12/31/2010", Operator:=xlAnd Columns("A:A").SpecialCells(xlCellTypeConstants, 21).EntireRow.Delete ActiveSheet.AutoFilterMode = 0
Last edited by davesexcel; 12-14-2014 at 08:26 AM.
Many thanks. It works well. I already clicked on * .
Just to learn, May I ask, what's the meaning of?.SpecialCells(xlCellTypeConstants, 21)
It's supposed to ensure that numbers get deleted not text, so a header won't get deleted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks