PDA

View Full Version : how to set function( input range )and (array output)!!



amrane
09-15-2014, 07:17 AM
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!!,:banghead:

Thank you for your support,
amrane
"

p45cal
09-15-2014, 07:41 AM
change:
bbta() = filter_ver0(bbta_log)
to:
bbta = filter_ver0(bbta_log)

amrane
09-17-2014, 06:55 AM
dear Mr p45cal

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

Br, Amrane