Glad it worked for you.

Alan

>Thanks Alan, I used an object and sent it as a parameter as you said.
>
>
>>The simplest way is to use an object setting the properties of the object to hold the values you want. Another way is to return an array, but personally, I'd rather use an object.
>>
>>Alternately, you could pass as many parameters as you need by reference, and change their values in the UDF.
>>
>>You can send the object as a parameter and fill the properties. When the UDF ends, the object has the info you need.
>>
>>Alan
>>
>>>Hi all, I'm wondering if there's a way to return more than one value from an UDF.
>>>
>>>I'd appreciate any help!
>>>
>>>Enmanuel