View Single Post
  #2   Report Post  
zipex
 
Posts: n/a
Default

Here is one way you could try, but it will go there and filter at the
same time (you may or may not want it) :shock:
If your list is in contiguous rows and columns, meaning no blank rows,
no blank columns, then setup autofilter. The dropdown list accepts
first letter.
Autofilter is setup using toolbar's Data, Filter, check autofilter
after you placed the cursor in the headings of your table. Not only
you'll be able to jump to a letter you want, but you will be able to
filter out the desired rows. The address of the cell then appears in
the address box.