Array formula will not copy any further- Help ASAP!
 

I have an array function that brings in the margins for pricing from another
sheet in the workbook. Currently, it has about 13,000 part numbers on it.
When I copy the formula normall, I use the drag box on the cells. Right now,
I am stuck on row 11,000 because the formula will no longer copy any further-
it just leaves the cells blank and bounces back to where I started to copy.
How can I fix this? I've tried everything from adding new cells to checking
the formatting of the cells. Any help would be greatly appreciated!

Array formula will not copy any further- Help ASAP!
 

"LJoe" wrote...
I have an array function that brings in the margins for pricing from
another sheet in the workbook. Currently, it has about 13,000 part
numbers on it. . . .

The other worksheet has 13,000 part numbers on it?

When I copy the formula normall, I use the drag box on the cells. . . .

OK, have you tried to copy the cell containing the presumably single cell
array formula, then select the range into which you would have filled it,
then paste into that range?