Lets say I have the following list of dates (in date format, not strings)
6/13/2012
7/12/2012
6/18/2012
I want to loop through and if the date contains the month of june and the year 2012, I then want to do something.
What would be the code for this? Many thanks
Are these the only 2 parameters or are there a list of conditions to be fulfilled?
What should the action taken if it finds the month and year?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Arlu1201
yes these are the only parameters?
The action taken will be to simply highlight in yellow all the dates with June 2012 in them. There are 1000s of dates in this list.
Many thanks
Assuming the dates are in column A
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks