Results 1 to 9 of 9

Ways of referring to entire Array row or column

Threaded View

EchoPassenger Ways of referring to entire... 09-17-2022, 03:04 PM
6StringJazzer Re: Ways of referring to... 09-17-2022, 03:34 PM
beyond Excel Re: Ways of referring to... 09-17-2022, 08:23 PM
EchoPassenger Re: Ways of referring to... 09-17-2022, 03:45 PM
beyond Excel Re: Ways of referring to... 09-17-2022, 08:40 PM
jolivanes Re: Ways of referring to... 09-17-2022, 09:04 PM
jolivanes Re: Ways of referring to... 09-18-2022, 01:05 AM
EchoPassenger Re: Ways of referring to... 09-18-2022, 04:33 PM
jolivanes Re: Ways of referring to... 09-18-2022, 05:12 PM
  1. #1
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    281

    Ways of referring to entire Array row or column

    Is there any way to refer to an entire row (or column for that matter) of a 2D Array, or must any reference only be to a single item/position i.e. array(1,1) etc ?

    For example, I if I have a 10 row x 10 column array and I want to join all of the values in each row, can I refer in some way to each array row to do that, or must I loop through each item to join them up?
    Last edited by 6StringJazzer; 09-17-2022 at 03:34 PM. Reason: clarified title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 2 ways array with multiple returns
    By Vibov in forum Excel General
    Replies: 1
    Last Post: 11-24-2020, 09:34 AM
  2. Replies: 7
    Last Post: 03-12-2017, 03:20 PM
  3. [NEED HELP]Array Formula by Referring to Few Criteria in Different Table
    By ulala2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-27-2016, 08:52 AM
  4. [SOLVED] Referring at an Array in different worksheet
    By Holbeck_Ghyll in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-05-2014, 10:42 AM
  5. Typing an array into a formula rather than referring to an array of cells
    By Cookstein2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-03-2013, 12:59 PM
  6. Referring to an array column or row of LinEst function
    By HammerTime in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-14-2010, 01:11 AM
  7. Referring to multiple elements of an array (VB)
    By Phil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2005, 12:50 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1