VBA Functions returning Arrays

[shen07]

Hi,

Actually im having problem with the following code, im returning an array using a function but only one value is displayed. Pleas Help

Please Login or Register  to view this content.

[Kenneth Hobson]

Welcome to the forum!

Either make it into an array, not a vector or use Transform. Also, when used a UDF, you need to select 3 vertical column cells, F2 to edit, =retcol(), and Ctrl+Shift+Enter.

Please Login or Register  to view this content.

[shen07]

Thanks..it Worked out..

Thanks a lot

[shen07]

However i have another question. If i dont know the size for the Array as above, how am i going to put it?

Please Login or Register  to view this content.

i have the codes above, now if i dont know the size of the range and how will i pass one by one in the before last line.