![]() |
|
|
|
#1
|
||||
|
||||
|
I thought maybe someone else would have a better answer, Wries, so I waited. But no one else has come up with a response yet, so I'll take a whack at it.
96 cells? That doesn't sound like very many; it isn't clear to me how that few cells could be slowing things down. How do you define "slow"? How much delay is there between <F9> and the end of the recalculation? I'm also not convinced that INDIRECT is the probable cause. I used to use it quite a bit—I've found some better ways since, or ways at least that I think are better—and although I thought it would slow things down, I didn't usually find it so. So what do you count as "slow"? |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Creating a TOC with sequential letters instead of page numbers at the right margin
|
shansen | Word | 1 | 03-11-2014 12:43 PM |
Convert String Array to Integer Array from a User Input?
|
tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |
Sequential document numbering excel'97
|
Scottlambert | Excel | 1 | 05-11-2012 03:40 AM |
Complex array formula
|
andrei | Excel | 9 | 02-03-2012 03:40 AM |
| How to count the frequency of data and also tally value from an array of Excel record | KIM SOLIS | Excel | 5 | 09-07-2011 09:01 AM |