+ Reply to Thread
Results 1 to 5 of 5

Referring to sheets by position

  1. 10-12-2015, 04:58 PM #1
    elmasguapo
    elmasguapo is offline
    Registered User
    Join Date
    10-03-2015
    Location
    west coast is the best coast
    MS-Off Ver
    excel 2010
    Posts
    113

    Referring to sheets by position

    Hello, how can I refer to sheets by position? I've created the sample code below but I don't think it will work. How can I improve? Thanks!!

    Please Login or Register  to view this content.
    Thanks!!
    Reply With QuoteRegister To Reply
  2. 10-12-2015, 05:56 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Referring to sheets by position 

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  3. 10-12-2015, 06:38 PM #3
    elmasguapo
    elmasguapo is offline
    Registered User
    Join Date
    10-03-2015
    Location
    west coast is the best coast
    MS-Off Ver
    excel 2010
    Posts
    113

    Re: Referring to sheets by position

    Ah I see. And then I put the reference after. The range reference, I mean.
    Reply With QuoteRegister To Reply
  4. 10-13-2015, 02:02 AM #4
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Referring to sheets by position

    Try:

    Sources:= array(Sheets(i).range("A1:B2") , Sheets(h).Range("A1:B10"))
    Reply With QuoteRegister To Reply
  5. 10-14-2015, 05:44 PM #5
    elmasguapo
    elmasguapo is offline
    Registered User
    Join Date
    10-03-2015
    Location
    west coast is the best coast
    MS-Off Ver
    excel 2010
    Posts
    113

    Re: Referring to sheets by position

    Hmmm, I tried that. Doesn't seem to work. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Copying a formula referring to the same cell of multiple sheets
    By Gardad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2014, 05:05 AM
  2. [SOLVED] How to maintain the formula referring to a cell in the same position
    By douglascaixeta in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-13-2014, 09:22 PM
  3. Hide sheets by finding sheet name in range and referring to other column for 'Hidden'
    By Bonnister in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-05-2014, 06:31 AM
  4. List the cells with data validation rules referring to other sheets/books.
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-07-2011, 11:22 AM
  5. Referring to data on other sheets
    By aquinlan in forum Excel General
    Replies: 8
    Last Post: 05-29-2010, 06:34 PM
  6. Referring to a sheet in an external workbook by position, not name
    By Chief Wiggums in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2008, 10:39 PM
  7. [SOLVED] Pivot shart referring to multiple sheets
    By Kanga in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-19-2005, 07:05 AM

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