Consulting

Results 1 to 3 of 3

Thread: how to set function( input range )and (array output)!!

  1. #1
    VBAX Regular
    Joined
    Jan 2011
    Posts
    55
    Location

    how to set function( input range )and (array output)!!

    Dear Forum,

    I am looking for your support, my case is as below:

    I made separate function to remove the repeated cells of the input range, than list-out the filtered item though array to be passed as result, so I need to correct form of function input argument as range, and returns back string array!!!

    in the attached file, the function code is running separately fine (see "Function filter_ver1()")=> the result() is list correctly the output strings,

    but its not working over the procedure "Sub BBTA_usage()" +"Function filter_ver1()", the results are not tranfered to the main program!!,

    Thank you for your support,
    amrane
    "
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,877
    change:
    bbta() = filter_ver0(bbta_log)
    to:
    bbta = filter_ver0(bbta_log)
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    VBAX Regular
    Joined
    Jan 2011
    Posts
    55
    Location
    dear Mr p45cal

    Thx a lot, I am wondering what happen for me!!

    Br, Amrane

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •