"Cannot change part of an array!"

E

ExcelMonkey

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
 
D

Duke Carey

After you select and copy the array formula, you cannot paste over that cell
- it has to be excluded from the range you want to paste into
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Compressing multiple functions across an array into one cell 6
Array formula lock-up 1
drag formula down from columns that go acros 3
Learning arrays. 13
Mapping integers to strings 6
INDIRECT with Sheet Level Defined Name 2
Need array formula to ignore hidden values 1

Top