mapping values of one array into another
 

I have an array of names that is generated by a set of formulas. I want to
be able to map each of these names into another array so that I have the
value only , the same as if I had done a copy of the first array and then
did a paste special into a new worksheet.

Thanks
Carl