Results 1 to 9 of 9

Alternative to INDIRECT for referencing Named Ranges

Threaded View

  1. 09-08-2023, 03:36 AM #7
    hamsuke
    hamsuke is offline
    Registered User
    Join Date
    09-08-2023
    Location
    Kuala Lumpur
    MS-Off Ver
    365
    Posts
    3

    Re: Alternative to INDIRECT for referencing Named Ranges

    Tried the formula, it will face the same slowdown in calculations as well, probably due to involving massive range (A:A). However, it is a good option if INDIRECT is not used haha.
    Last edited by AliGW; 09-08-2023 at 03:43 AM. Reason: Please do NOT quote unnecessarily! Use the QUICK REPLY button instead.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Alternative to INDIRECT with dynamic named range
    By gak67 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-12-2020, 04:38 PM
  2. Need ADO alternative VBA to merge and remove duplicates of multiple Named Ranges
    By ravikiran in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2017, 11:46 AM
  3. Non-Volatile Alternative: Cell or Indirect and Address for Named Range Formula
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2015, 10:02 AM
  4. INDIRECT not referencing named range which exists on another sheet
    By rikkyshh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2014, 06:55 AM
  5. Using INDIRECT with named ranges
    By wunderfisch in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-17-2013, 01:10 PM
  6. [SOLVED] INDIRECT and Named Ranges referencing closed workbook
    By gpie in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-06-2005, 07:05 PM
  7. referencing named formula using INDIRECT function
    By rob.hick@nbs.nhs.uk in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 05-11-2005, 05: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1