View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rizello rizello is offline
external usenet poster
 
Posts: 2
Default how to use Replace function to change worksheet names

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