The xl97 help file (for instance) has several topics dealing with arrays.
Suggest you start your quest there. In help search for...

Using Arrays
Declaring Arrays
Array Function
ReDim Statement
Variant Data Type
Writing a Function Procedure
--
Jim Cone
Portland, Oregon USA



"xavi garriga"

wrote in message
Dears;
I'm making a macro using arrays for first time, and in a sub procedure I'd
like to create a multidimensional array with different types of variables.
One column should have a string of characters and the rest of the columns
should have numeric values. How can I define this array?

When this array is created, how can I call it in a function?

Please, if I haven't clarified enough the question, let me know...

Thanks for your help!
--
atrep