Autocomplete only kicks in when there is a unique match in the list to
what you have typed. Are you sure it's not that behaviour that you are
seeing? (the more entries you have, the more likely it is you have to
type more characters to get a unique match).


John;716721 Wrote:

Autocomplete only seems to function if there are not a lot of rows
between
the active cell and the matching text (all rows above the active cell
are
non-blank). For example, if there are a dozen or so rows between the
active
cell and the matching text cell, autocomplete works fine. If there are,
say
50 rows between the active cell and the matching text cell, you must
type
more characters for autocomplete to complete your text. If there are
several
hundred nonblank cells between the active cell and your matching text,
autocomplete ceases to function. Any one know a workaround?


--
aflatoon

Regards,
A.
------------------------------------------------------------------------
aflatoon's Profile: http://www.thecodecage.com/forumz/member.php?u=1501
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=200690

http://www.thecodecage.com/forumz