+ Reply to Thread
Results 1 to 3 of 3

Using CodeName to Move to a Sheet

  1. #1
    Forum Contributor
    Join Date
    07-10-2020
    Location
    New Zealand
    MS-Off Ver
    365 personal
    Posts
    210

    Using CodeName to Move to a Sheet

    I need a VBA Code Line that will move me to a Sheet that has the Codename Sheet1.

    I have tried various lines of code and including the current code in the attached file nothing works

    Please Login or Register  to view this content.



    I understand that I do not need to refer to the name of the Workbook as the codename will only work for the workbook it belongs to.

    Can someone supply the correct code?

    Thanks

    Allister
    Last edited by AllisterB; 06-14-2021 at 01:27 AM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,140

    Re: Using CodeName to Move to a Sheet

    Just
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-10-2020
    Location
    New Zealand
    MS-Off Ver
    365 personal
    Posts
    210
    Thanks jindon
    I'm glad it didn:t take a lot of your time
    😄
    Allister

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can not change Sheet codename
    By Master_Sergius in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 02-20-2020, 10:55 AM
  2. Getting Sheet name from codename?
    By aquixano in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2017, 01:42 AM
  3. [SOLVED] VBA sub for sheet with codename
    By Roadhouse in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2016, 04:00 PM
  4. [SOLVED] Sheet Codename
    By Ravana in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2015, 12:34 PM
  5. [SOLVED] Selecting sheet by codename in a multi sheet code
    By jshaw82 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-18-2013, 10:46 AM
  6. trying to use sheet CodeName to list all sheet names in a workbook
    By neowok in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2012, 12:06 PM
  7. Get sheet (CodeName) not .Name
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-14-2010, 01:54 PM

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