see your other post

--
Biff
Microsoft Excel MVP


"anirban" wrote in message
...
the auto completion is not searching the entire document fro values
entered
earlier in a coloum rather it is searching only a part of of the column
and
is giving me values based on that can any one please help..???