+ Reply to Thread
Results 1 to 2 of 2

calling function, returning one element of the array

  1. #1
    Registered User
    Join Date
    07-14-2010
    Location
    sweden
    MS-Off Ver
    Excel 2003
    Posts
    14

    calling function, returning one element of the array

    Hi!
    I have a function looking something like:

    Please Login or Register  to view this content.
    So if this wouldnt have been an array i would call it like returnarray(value1, value2).

    But in this case i'm interested in the first position of the array.
    Please Login or Register  to view this content.
    Until now i've made a new array in the "active sub":
    Please Login or Register  to view this content.
    I would like to do this without that step in between.. Is this possible?
    Last edited by romperstomper; 08-02-2010 at 04:50 AM. Reason: Additional code tags

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,256

    Re: calling function, returning one element of the array

    You don't need an array variable in the calling sub:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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