+ Reply to Thread
Results 1 to 3 of 3

Using INDIRECT in Sheets.Select Function

  1. #1
    Registered User
    Join Date
    07-05-2021
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    6

    Using INDIRECT in Sheets.Select Function

    Hello Everyone,

    I have a code that I am running which has the line,

    Sheets("Retirement").Select

    I would like to change it to something like this, where A1 has the name of the sheet I would like to select.

    Sheets([indirect("A1")]).Select

    The above is not working. Please help.

    Thanks

  2. #2
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,359

    Re: Using INDIRECT in Sheets.Select Function

    Please Login or Register  to view this content.
    If things don't change they stay the same

  3. #3
    Registered User
    Join Date
    07-05-2021
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Using INDIRECT in Sheets.Select Function

    Thanks so much! Works perfectly.

+ 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. Using Indirect function to sum across multiple sheets
    By Irishman07 in forum Excel General
    Replies: 10
    Last Post: 02-14-2018, 05:26 PM
  2. [SOLVED] Marco vs Indirect to select sheets
    By EirikN in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2016, 07:06 AM
  3. [SOLVED] INDIRECT Function over multiple sheets
    By Cdigglesworth in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 01-14-2015, 03:17 PM
  4. [SOLVED] INDIRECT Function with multiple sheets - SUMIF, INDIRECT & MATCH
    By DJDRU in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2014, 08:42 AM
  5. [SOLVED] Using INDIRECT function within Chart 'Select Data' formula?
    By essee in forum Excel General
    Replies: 4
    Last Post: 11-09-2012, 07:00 AM
  6. Replies: 2
    Last Post: 12-20-2010, 09:59 PM
  7. [SOLVED] Sum Indirect function through multiple sheets
    By Andre Croteau in forum Excel General
    Replies: 2
    Last Post: 05-06-2005, 06:06 AM

Tags for this Thread

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