Hi Rizello,

You try to replace a text Nov to Dec, or you have dates like 11/1/2006
formated as Nov?

if it's a date try to replace 11 to 12, DO NOT FORGET to do a backup of your
sheet before.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"rizello" escreveu:

I have a file with multiple worksheets (one for each day). I want to change
the name of each worksheet to the name of the month.

For example, I want to change 'Nov' to 'Dec' in all of the worksheets in the
file.

When I use the Replace function, it says it can't find the data it is
looking for.

Thanks