Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    May 2012
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unique Renaming of Worksheet

    I have a workbook where the worksheets are copied and renamed in a loop. My problem is that when the first worksheet is created it is renamed Test_606 however, when the next worksheet is created it is also renamed as Test_606 but not saved because cannot have duplicate worksheet names.

    How can I add a line that would add a (2) for the the second copy, (3) for the third and so on.

    so it would say Test_606, Test_606 (2), Test_606 (3)

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Could you please post your loop code?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •