Sorry, this may be a dumb question but my mind just can't seem to find the answer this morning. \:\)

I want to use a UDF which returns an array. The size of the array will vary. How do I declare my variable to hold the returned array with the proper dimensions? If I declare it with length 0, will the function call automatically redim it with the returned array size?