FSt1 wrote:
hi
auto complete looks at data in the same column above the activecell so
autocomple will not work in another column.
sorry
regards
FSt1

"elihue" wrote:

I have excell 2000 and have 300 names in one column and would like for excell
to auto complete on another column but it wont. When I went to HELP, all I
canfigure out is it says its out of my data region but I don't know how to
change that.

Would a custom list be of any use to you, just a thought.
Cheers L