Alphabetic Sort Function?

[Mike]

Hi,

I have an alphabetically sorted list of words, names, etc., now approaching
over 2000 rows.

I need a "button" to hit which pops up a window with buttons for the
letters, and I just hit the button for the letter I want to scroll to.

Any help with this would be apreaciated.

Thanks,

Mike

 

[David McRitchie]

Hi Mike,
The following Event macro will work for you, no button required
you just double-click. See top of web page for installing.
l
Worksheet Events and Workbook Events
MATCH Worksheet Function in a macro as a substitute
for hyperlinks, in a a name and address list. (#match)
http://www.mvps.org/dmcritchie/excel/event.htm#match