From what it sounds like you want done I would probably write a one
time use macro to go through and replace the contents of the month only
cells with month+today. Let the macro do all the finding and replacing.
Or, you could possibly do a Find and Replace from the Edit menu and
restrict it to the row or column that has the cells you want to change.


For example:
Find January
Replace with ="January "&Year(TODAY()) (Note the space after January.)
Which will give you January 2005 for this year.

If your month cells are scattered thoughout the worksheet or if you
have cells that contain the month that you don't want changed that may
be a bit more difficult to accomplish but I think it could still be
done using the Options button.

Bill