I downloaded a worksheet containing 3 excel functions. Each function
takes 2 parameters and returns an array containing calculated values.
For example, the 2 parameters are glucose and insulin and returns an
array containing calculated values for 3 variables called HOMA2B,
HOMA2S and HOMA2_IR.

What I want to do is copy the numbers that the array calculates for
HOMA2B, HOMA2S and HOMA2_IR and paste them in another Excel
worksheet. When I try to just copy and paste I get a message saying
something like "you can't change an array" or sometimes I get an error
message saying #NAME? where I've tried to paste it.

Can anyone help me with this? Thanks.