Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro that ends with a resulting list of parts. One column has a
Date Added column and I want to select specific dates within it. I want parts with a date of the last 18 months selected and deleted. Now I'm not certain what the code would look like in the macro. Is there a way to select everything with the date of the last 18 months? The date is in this format: 1/1/2006 = January 1, 2006 12/12/2006 = December 12, 2006 etc. Now I could put it in there probably to select the last 18 months from this date, though that would hardly be automated, because next month I would have to go into the code and modify it, then the next month, and so on. I wanted a universal way of doing it so the last 18 months regardless of the month I'm in will be selected and deleted. make sense? Thanks for the help!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for date selection | Excel Discussion (Misc queries) | |||
find date and copy selection | Excel Programming | |||
Can I set up a calendar lookup for date selection | Excel Discussion (Misc queries) | |||
Date selection loop | Excel Programming | |||
Date Selection Userform | Excel Programming |