| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
We were wondering how to edit an array once it has been set up?
We have a transpose array set up for a program sheet. We need to increase the
number of cells it pulls from but we get an error message stating we cannot change an array. How do you change an array without having to start over? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
We were wondering how to edit an array once it has been set up?
Click in *any one* of the cells that contain the array formula.
Make your revision(s) ... and hit CSE (<Ctrl <Shift <Enter). This changes *all* the formulas in the array in a single shot! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Kfalcone" wrote in message ... We have a transpose array set up for a program sheet. We need to increase the number of cells it pulls from but we get an error message stating we cannot change an array. How do you change an array without having to start over? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
We were wondering how to edit an array once it has been set up
This works. Thanks so much for the help!
"RagDyer" wrote: Click in *any one* of the cells that contain the array formula. Make your revision(s) ... and hit CSE (<Ctrl <Shift <Enter). This changes *all* the formulas in the array in a single shot! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Kfalcone" wrote in message ... We have a transpose array set up for a program sheet. We need to increase the number of cells it pulls from but we get an error message stating we cannot change an array. How do you change an array without having to start over? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
We were wondering how to edit an array once it has been set up
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Kfalcone" wrote in message ... This works. Thanks so much for the help! "RagDyer" wrote: Click in *any one* of the cells that contain the array formula. Make your revision(s) ... and hit CSE (<Ctrl <Shift <Enter). This changes *all* the formulas in the array in a single shot! -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Kfalcone" wrote in message ... We have a transpose array set up for a program sheet. We need to increase the number of cells it pulls from but we get an error message stating we cannot change an array. How do you change an array without having to start over? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display an array of references | Excel Worksheet Functions | |||
| Add Permission did not work in "Allow User to Edit Ranges" | Excel Discussion (Misc queries) | |||
| Edit and Array | Excel Worksheet Functions | |||
| defintion of array function | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Linear Mode
