+ Reply to Thread
Results 1 to 3 of 3

Retrive more then one object from function

  1. 10-03-2018, 06:06 AM #1
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Retrive more then one object from function

    Hi,

    my code is:

    Please Login or Register  to view this content.
    i want to retrive ArrayVariant also from function and pass it to main sub.

    Please help,
    Best,
    Jacek
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-03-2018, 06:52 AM #2
    rorya
    rorya is offline
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Retrive more then one object from function

    You could do something like this:

    Please Login or Register  to view this content.
    or, probably more logical, something like this:

    Please Login or Register  to view this content.
    Rory
    Reply With QuoteRegister To Reply
  3. 10-04-2018, 01:19 AM #3
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Retrive more then one object from function

    hi rorya,

    thank you very much!
    It is helpful!

    Best,
    Jacek
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Retrive last value from corresponding column
    By SHIVA_2018 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2018, 05:47 AM
  2. Macro to insert object (Create from file): Show Object Type/Name and Limit Object Size
    By ININ1994 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2014, 02:09 PM
  3. [SOLVED] excel function on how to retrive piece of text from range of cells
    By Rohit2500 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-02-2013, 03:39 AM
  4. Function to return object reference given object name
    By 6StringJazzer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2010, 09:07 PM
  5. Retrive only first name.
    By Wskip49 in forum Excel General
    Replies: 3
    Last Post: 08-27-2008, 11:23 AM
  6. Retrive Data
    By Tax User in forum Excel General
    Replies: 4
    Last Post: 10-28-2007, 11:32 PM
  7. [SOLVED] function to retrive last entry in a column
    By rsanandkumar in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-04-2006, 03:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1