View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LJoe LJoe is offline
external usenet poster
 
Posts: 9
Default 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!