Hi All,
I have a sheet that has a set of data for each row. There are a large
number of rows of data. We keep this data sorted alphabetically by
the data in cells of the A column. I've written 26 nearly identical
macros that allow users to hit Shft+Ctrl+"Letter" and it will take them
to the first row that starts with that "Letter". Since the users do
this a lot, it is very efficient to have only a single keystroke combo
(ctrl+shft+letter). The problem is, I hate using up all of the
Ctrl+Shft shortcuts available. Can anyone think of a way, with a
single keystroke combination, to accomplish the same thing, preferably
without having 26 separate macros and without using up all of the
Ctrl+Shft shortcuts? Also, are there any other shortcut keys that you
can assign to macros besides just "Ctrl+" or ""Ctrl+Shft+". Thanks
heaps for any help!


--
FuzzyDove
------------------------------------------------------------------------
FuzzyDove's Profile: http://www.excelforum.com/member.php...o&userid=16676
View this thread: http://www.excelforum.com/showthread...hreadid=320629