+ Reply to Thread
Results 1 to 3 of 3

Function that return Array

  1. #1
    Registered User
    Join Date
    11-05-2010
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    59

    Function that return Array

    Hi Guys,

    I am trying to construct an array in a function and return in but it doesnt work.
    for example, the below function contruct an array
    Please Login or Register  to view this content.

    Then in a sub, I try this

    Please Login or Register  to view this content.
    But it is not working? any idea how I could achieve this?
    Thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,540

    Re: Function that return Array

    What makes you think it's not working?

    Please Login or Register  to view this content.

    Stepping through ...

    Please Login or Register  to view this content.

    What's it doing, or not doing, that it shouldn't do, or should do?


    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Function that return Array

    or to keep it simple:

    Please Login or Register  to view this content.
    Last edited by snb; 07-08-2011 at 06:12 AM.



+ 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