how to use Replace function to change worksheet names

R

rizello

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
 
M

Marcelo

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:
 
W

Wiley

AFAIK, Rreplace does not look at sheet names. Renaming sheets is a manual
process, unless you create a VBA macro. It sounds like you are doing this
each month. You could get aorund this by not including the month in the
sheet names, and, and keeping the month in the file name. The sheet name is
just the numeric day.
 
Top