I have data comming in that will give me a value, 1-5. I want to
assign a var baised on the data comming in, to an array (all arrys in
sheet have names) so I can use it (the array) in another equ.

is there an equasion that will output an array, either an existing
array or a new one? That would help too

In article .com,
says...
I have data comming in that will give me a value, 1-5. I want to
assign a var baised on the data comming in, to an array (all arrys in
sheet have names) so I can use it (the array) in another equ.


I don't understand what it is you want to do. How about an example?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Ex.

User form outputs a value; Using existing data, I want to assign the
form data (number 1-4) to a array, to get the value from a table(4x4).
User data will change so that is why I need an array var to be dynamic.

In article .com,
says...
Ex.

User form outputs a value; Using existing data, I want to assign the
form data (number 1-4) to a array, to get the value from a table(4x4).
User data will change so that is why I need an array var to be dynamic.


OK, hopefully someone else will pitch in. Simply restating the
original post and claiming it is an example doesn't really make it one.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions