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.
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.
Last edited by Leith Ross; 07-30-2013 at 06:04 PM. Reason: Added Code Tags
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.
Thanks..it Worked out..
Thanks a lot
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.
Last edited by Leith Ross; 07-30-2013 at 06:04 PM. Reason: Added Code Tags
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks