| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions/arrays
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Functions/arrays
Instead of doing <paste after the <copy, do Edit | Paste Special |
Values (check) | OK then <Esc. Hope this helps. Pete On Jul 11, 12:21 am, LLama wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Functions/arrays
Thanks!!
On Jul 10, 8:20 pm, Pete_UK wrote: Instead of doing <paste after the <copy, do Edit | Paste Special | Values (check) | OK then <Esc. Hope this helps. Pete On Jul 11, 12:21 am, LLama wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Functions/arrays
You're welcome.
Pete On Jul 11, 1:39 am, LLama wrote: Thanks!! On Jul 10, 8:20 pm, Pete_UK wrote: Instead of doing <paste after the <copy, do Edit | Paste Special | Values (check) | OK then <Esc. Hope this helps. Pete On Jul 11, 12:21 am, LLama wrote: 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.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arrays/Functions/Different datatypes in a formula? | Excel Worksheet Functions | |||
| passing arrays to user defined functions | Excel Worksheet Functions | |||
| Linking worksheet functions and arrays - Doozie | Excel Discussion (Misc queries) | |||
| Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
| Arrays parameters in Functions | Excel Worksheet Functions | |||
Linear Mode
