+ Reply to Thread
Results 1 to 4 of 4

Saving Sheet Name from An Array not Working Anymore

  1. #1
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    478

    Saving Sheet Name from An Array not Working Anymore

    Hi guys,

    I need some help with this macro.
    Saving sheet names from an array of names doesn't work anymore and i don't know why.
    After some patch Excel is running odd and is not doing what it should do. This line of code doesn't work anymore ==> ThisWorkbook.Sheets(i).Name = Names_Array(m)

    Please Login or Register  to view this content.
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  2. #2
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    2013
    Posts
    3,484

    Re: Saving Sheet Name from An Array not Working Anymore

    What error message do you get?
    Also how many sheets are you copying & from how many workbooks?

  3. #3
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    478

    Re: Saving Sheet Name from An Array not Working Anymore

    got no error, but the files are copied with their own name reportXXXX. i am copying 9 books.
    Seems that the error was just because there were some hidden sheets in the workbook.
    Don;t know why!

    Thank you!

  4. #4
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    2013
    Posts
    3,484

    Re: Saving Sheet Name from An Array not Working Anymore

    Glad you resolved it & thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1