Ken,

I had never noticed that there was a limit on number of cells till
AutoComplete works...

I tested out with Excel 2007 on XP... it seems that it takes more time to
suggest the entry farther you go away... i tested upto 450... somewhere after
400 I had to type first two letters to get the suggestion...

It would be great to get more information on how it is implemented in Excel...


"Ken Johnson" wrote:

It doesn't solve the other problem Biff mentioned where excel only
looks so far. 51 cells away seems to be the limit on my machine (XP
and xl2003).

Ken Johnson