Is there any way to subvert autocomplete so that it does it's looking up in
a range other than the active column?

The effect I'm trying to achieve is have a list of names in one place, list
A, and have the user entering names in another, list B, but have the auto
complete use list A for doing the autocomplete and not list B.

I realize with some really ugly and massive use of OnKey and AutoComplete I
can give the illusion of this but that's unacceptable. I want to subvert
Excel's built in feature.

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley