I am looking for a macro that can update formulas with
the current month. The simplest use would be to update a
formula that last month referenced last month to a
formula that now reference the current month. Example:
Last Month the formula = [REPORT JUN 04.xls]SHEET1'!A1.
This month I want the formula updated to = [REPORT JUL
04.xls]SHEET1'!A1.

I am trying to use a simple "Find & Replace"
and/or "Links Change" plus code that Tom Ogilvy wrote.
But I can 't get either to work. In the "Find & Replace"
I am using variations (for Date format "mmm yy":

Cells.Select
Selection.Replace What:=Today()-1), Replacement:=today
(),LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

And it creates a syntax error. With Links Change I
get "Argument Not Optional" error on .ChangeLink Name:=

Thanks to all that have helped and any additional help
will be very much appreciated.