"Rick Rothstein" wrote:

Any chance you can change all formulas that contain a month name to use a
cell reference instead of the text month? For example, if you had a formula
in your workbook like this...

=IF(B2<"","January's value is"&B2","")

and A1 was a currently unused cell, You could write January in A1 and change
the formula to this...

=IF(B2<"",A1&"'s value is"&B2","")

If you made similar changes to all your formulas that specified the month's
name in text form, then just changing A1 would automatically update all the
formulas at once. This would be much faster than executing a macro that
looked at, and changed, each formula with the month name in text form. If
you can do this, fine. If not, then are there more than one worksheet in
your workbook?

--
Rick (MVP - Excel)


Do not think I can do that cause the text for the month is part of a file
name such as "January numbers.xls" EX. one formula is this
=IF(ISERROR(VLOOKUP($A40,[January numbers.xls]Sheet
1!$Y$4:$AI$500,5,FALSE)=TRUE)," ",(VLOOKUP($A40,[January numbers.xls]Sheet
1!$Y$4:$AI$500,5,FALSE)))

I have over a thousand formulas altogether and the file that they link to
change each month so I would like it to update based on what the current
month is. I hope this example would help.