View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nick Hebb Nick Hebb is offline
external usenet poster
 
Posts: 162
Default Forcing autocomplete to lookup from a range of cells

By default, when you're typing in a cell entry, Autocomplete finds
matching entries from the previous entries above in the same column.
Is there a way to force Autocomplete to lookup values from a designated
range of cells?