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....