Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,231
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Help-ASAP Lisa Excel Discussion (Misc queries) 6 June 1st 07 03:31 PM
Can I copy an array in a conditional formula Theo Excel Discussion (Misc queries) 4 April 11th 07 08:52 PM
How do I copy an array formula? cguen Excel Discussion (Misc queries) 1 August 28th 06 04:42 PM
copy array formula JR573PUTT Excel Worksheet Functions 2 February 16th 06 10:12 PM
Copy An Array Formula JR573PUTT Excel Discussion (Misc queries) 2 February 16th 06 08:57 PM


All times are GMT +1. The time now is 05:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"