Array formulas will not copy.

[Steve Clarian]

I have an "index(match" type of array formula that I need
to copy across about a dozen columns, and down 12700
rows. When I try to drag it down, it autofills down to
row 4093, but the cells in the rows beneath that remain
empty - the formula is not copied into them. And if I try
dragging the formulas down again starting at row 4093,
they still won't copy. Rows 4094 down just stubborly
remain empty.

Any ideas what could be causing this? Thanks!

 

[Bernie Deitrick]

Steve,

I don't know why it won't copy down past row 4092, but if you describe what
your formula is doing, perhaps we can suggest a different way - perhaps a
non-array formula or a macro - that will work.

HTH,
Bernie
MS Excel MVP