+ Reply to Thread
Results 1 to 4 of 4

Trying to slice an array

  1. #1
    Registered User
    Join Date
    06-22-2016
    Location
    Minnesota
    MS-Off Ver
    2013
    Posts
    20

    Trying to slice an array

    As stated on other posts, I'm a rookie and am now trying to learn how to slice arrays using the method shown here: https://usefulgyaan.wordpress.com/20...lication-index.

    However, when using the test code shown below, I get a "subscript out of range" message for the MsgBox command. Can anyone tell my why arrtemp(1) will not return a value? I want to be able to slice off the columns of the arrtest array into a 1-dimensional array so that I can easily mind the max/min value of the column. TIA.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    06-22-2016
    Location
    Minnesota
    MS-Off Ver
    2013
    Posts
    20

    Re: Trying to slice an array

    Mods, please delete this post, I accidentally double-posted with then one above.

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Trying to slice an array

    MsgBox (arrtemp(1, 1))

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Trying to slice an array

    Please Login or Register  to view this content.

+ 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. NO slice/filter for SUM
    By martijnvanderveldt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-08-2015, 06:11 AM
  2. Pie of Pie: angle of first slice?
    By 10 Dollar Bill in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-20-2014, 03:34 AM
  3. Pulling one slice from a 3D matrix
    By mattcschmidt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-03-2014, 02:12 PM
  4. [SOLVED] Pie Chart Help! Slice explosion?
    By pwall1115 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-13-2013, 10:29 AM
  5. How to slice the axis
    By dian_ks in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-19-2013, 04:05 AM
  6. slice image into cells
    By tek9step in forum Excel General
    Replies: 2
    Last Post: 02-06-2011, 06:27 PM
  7. Dividing a slice of a pie chart
    By sessy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-29-2009, 05:02 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