Date to be placed into Column "C" with matching value in Column "B" in same row

Corey

Guest

Posts: n/a

17th Jan 2007

I have in Sheet1.

B17 = January 07
B18 = February 07
...
...
B28 = December 07

These Months/yrs are in range("B17:B28").

How can I have the current Month and Year placed into the cell to the Right of the matching Month and Year.
IE. Range("C17:C28") ?

If January 07 is in B17 then C17 is to have "Now( ) mmmm yy" placed in it by code when "Now ( )" is January 07 etc....

I want this to occur at the end of running a macro in another sheet, but cannot figure out how to get it placed in the right cell along side of the B Column value.

Corey....

« VBA randomize vs. srand | Extract Info From All Files in a Directory Q »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
macro is to update column 13 and 14 of worksheet "Voice BB Pending"as per column 2 and 3 of "Activity log" .	San	Microsoft Excel Programming	1	19th Aug 2010 11:19 AM
"RECEIVED" column date is set to "None" in Outlook 2003	Johnny37	Microsoft Outlook Discussion	2	16th Apr 2010 02:16 PM
Convert a column from "Short Date" to "Long Date"	Curious	Microsoft Dot NET	0	25th May 2007 03:23 PM
Re: Date to be placed into Column "C" with matching value in Column "B" in same row	Corey	Microsoft Excel Programming	0	18th Jan 2007 03:20 AM
Re : Date to be placed into Column "C" with matching value in Column "B" in same row	Corey	Microsoft Excel Programming	1	18th Jan 2007 01:06 AM