Interesting, I didn't know that, always thought it was single column
centric, not region.


--
Regards,

Peo Sjoblom



"JE McGimpsey" wrote in message
...
Neither right, nor wrong.



Autocomplete operates on the "active data region", i.e., there must be
no completely blank rows between the list and your entry.

For example, when making an entry at <entry,

Autocomplete works

A B
1 data1 1
2 data2 2
3 data3 3
4 <blank 4
5 <blank 5
6 <entry 6

Autocomplete doesn't work:

A B
1 data1 1
2 data2 2
3 data3 3
4 <blank <blank
5 <blank 5
6 <entry 6





article ,
Gringo wrote:

It seems that auto complete has previously worked for me when there was a
separation of several rows at least. Today it will only auto complete
for
the next cell down. Is this right or wrong?