• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. N

    Can not reference sheet , through Sheet's Code Name

    The Pitfall will always be there if that worksheet was deleted or even just renamed (external or internal) So why not to check if a worksheet exists in an external workbook by it's codename and - if so - access the worksheet by its name? So you check the worksheet exists and enum the...
  2. N

    Can not reference sheet , through Sheet's Code Name

    Maybe this can help: https://www.spreadsheet1.com/vba-codenames.html /Willy
  3. N

    Can not reference sheet , through Sheet's Code Name

    To activate a Sheet by it's Codename I'm using ThisWorkbook.VBProject.VBComponents(CODENAME).Activate Regards /Willy
Back
Top