Array formulas will not copy.

  • Thread starter Thread starter Steve Clarian
  • Start date Start date
S

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!
 
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
 
Back
Top