View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
rizello rizello is offline
external usenet poster
 
Posts: 2
Default Rename all existing worksheet tabs

Hello:

I would like to do this also. Is it possible to do without using VBA, but
simply a command in Excel?

"MikeM" wrote:

I would like to take an existing workbook and rename all the worksheet tabs
at one time. For example, I might have ten worksheets with various names and
I'd like them all to be named USA1, USA2, USA3 and so on.

Can this be easily done with some VBA code? (I've seen some similar
questions, but none exactly like this one.)

Thanks.