LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 93
Default Date Selection

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for date selection glitterjen Excel Discussion (Misc queries) 2 July 25th 07 10:34 AM
find date and copy selection redb Excel Programming 0 January 31st 06 11:31 AM
Can I set up a calendar lookup for date selection Tangoxray Excel Discussion (Misc queries) 1 October 27th 05 12:55 PM
Date selection loop Roger[_8_] Excel Programming 12 September 26th 04 12:53 AM
Date Selection Userform Archie[_2_] Excel Programming 2 April 13th 04 07:05 AM


All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"