VBA - rename tabs beginning with the SECOND tab in file

  • Hi. I have the following code to rename worksheet tabs each month, but the first sheet in every file will always be SUMMARY, with the following sheets numbered "month-day" (9-1 for example), so I need this code to skip the first tab and begin with on the second tab with (in this example) "9-1". Is there a way I can do this? Thanks!




  • Re: VBA - rename tabs beginning with the SECOND tab in file


    Code
    For i = 1 To 31: Worksheets(i+1).Name = "9-" & i: Next

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!