+ Reply to Thread
Results 1 to 4 of 4

Jagged Arrays: Syntax Clarificatiuon

Hybrid View

cmore Jagged Arrays: Syntax... 04-26-2016, 03:05 PM
shg Re: Jagged Arrays: Syntax... 04-26-2016, 03:29 PM
cmore Re: Jagged Arrays: Syntax... 04-26-2016, 03:56 PM
shg Re: Jagged Arrays: Syntax... 04-26-2016, 05:46 PM
  1. #1
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Jagged Arrays: Syntax Clarificatiuon

    Hi,

    So I just wanted to clarify something before I have a Nergasm. I was fumbling around trying to fill some arrays quickly and saw different syntax. What does it mean if my array has to be referenced


    Array(1)(0,1) instead of Array(0, 1)?


    My code is all over the place, so to try and keep from confusing me further and anyone else, let's not go there..............just wondering about what the diff. array syntax might mean?


    Thank you in advance
    (feel free to point me to resources where a not-dumb person might look, I luvs to do me some book lurnin)

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Jagged Arrays: Syntax Clarificatiuon

    Array(1) is an element of a 1D array.

    Array(1)(0,1) is an element of the array contained in Array(1). Since only Variants can contain arrays of arrays, Array must be a Variant.

    The second syntax refers to an element of a 2D array of unknown (any) type.
    Last edited by shg; 04-26-2016 at 03:32 PM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Re: Jagged Arrays: Syntax Clarificatiuon

    Thanks! As usual, you're a gentleman and a scholar!

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Jagged Arrays: Syntax Clarificatiuon

    You're welcome.

+ 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. [SOLVED] Looping thru arrays with dynamic names. Array1/2/3/5, how to array(Array & i) syntax?
    By graym463 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-24-2015, 10:15 AM
  2. Declaring multiple multi-dimensional arrays (jagged arrays) - compile error?
    By dfribush in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-20-2013, 05:06 PM
  3. Syntax for arrays and loops in VBA
    By DataMole in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2012, 12:43 PM
  4. Syntax for Passing Arrays to Functions
    By ffffloyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2009, 08:34 PM
  5. Jagged Pie Charts
    By Sionos in forum Excel General
    Replies: 0
    Last Post: 09-25-2007, 05:54 AM
  6. [SOLVED] soften jagged edges of pie charts
    By zen in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-17-2005, 02:05 PM
  7. Syntax Laurent Longre's Morefunc VSORT with arrays?
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-10-2005, 04: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