| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Cannot change part of an array!"
Why am I getting this message. I have an array formula in E614. I am trying
to copy it across and down to fill the range E614:I633. I have been copying these arrray formulas across this range with no problem at all. Now all of a sudden I have changed one of the functions within the array formula and now Excel will not let me copy across columns and down rows. The only way I can do it is if I copy cell by cell. Why is this?? Thanks EM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change "automax" to "autosum"? (probablyl wrong terminology) | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Change data in a single column from "last, first" to "first last" | Excel Discussion (Misc queries) | |||
| =IF(D13="PAID","YES","NO") Can I change fonts colour | Excel Discussion (Misc queries) | |||
Threaded Mode
