+ Reply to Thread
Results 1 to 2 of 2

Refer to Sheets in formula VBA

  1. #1
    Registered User
    Join Date
    07-31-2015
    Location
    Amsterdam,Netherlands
    MS-Off Ver
    2010
    Posts
    8

    Refer to Sheets in formula VBA

    Dear all,

    I have a workbook which contains 400 sheets. The sheets are updated every day. On the first sheet there is a "Main" sheet were i'm trying to build a matrix which counts certain things from every sheet. In the martix I want to make a formula which refers to a the corresponding sheet. I have a list of words (the names of the sheets) on the "Main" sheet were I can reference it to. I got it to work with the INDIRECT function, but is was very very slow. Does anyone have a good idea how to make is faster, perhaps without INDIRECT?
    Or can this be done in VBA?

    Thanks in advance!
    PS: I have attached a small printscreen of my problem.

    Capture.PNG

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Refer to Sheets in formula VBA

    Duplicate thread: http://www.excelforum.com/excel-form...-inderect.html

    Please don't post duplicate threads, albeit with different titles. Most people will look at all the sub-forums.

    And please don't post pictures ... they're useless.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Refer to Sheets in Formula without INDERECT
    By gerarddevries in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-04-2015, 05:41 AM
  2. [SOLVED] How to refer to more than one sheet with With Sheets
    By mario274 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-03-2012, 12:03 PM
  3. Replies: 18
    Last Post: 05-17-2011, 02:31 PM
  4. Dragging formulas that refer across sheets
    By DPGDPG in forum Excel General
    Replies: 6
    Last Post: 11-23-2009, 04:31 AM
  5. #REF in Sheets that refer to Pivot Tables
    By Will C. in forum Excel General
    Replies: 1
    Last Post: 06-02-2006, 03:54 PM
  6. using a listbox or combobox to refer to columns or sheets
    By fern in forum Excel Programming / VBA / Macros
    Replies: 36
    Last Post: 04-03-2005, 01:42 AM
  7. [SOLVED] Refer to a defined name in a formula
    By in forum Excel General
    Replies: 3
    Last Post: 01-06-2005, 01:06 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