Hyperlinks

[KJ MAN]

Can a hyperlink in Excel reference a starting position on a list?

For example
Hyp[erlinks: A B C D ....... Z
Clicking on F will take the view and active cell to
the first cell in a column that has the letter F as the
1st character.

Thanks

 

[dustinbrearton via OfficeKB.com]

I would thinkg that would be easier to do with buttons. You could make a Sub
that would search like you are saying and then call that sub under the
on_click event.

Can a hyperlink in Excel reference a starting position on a list?

For example
Hyp[erlinks: A B C D ....... Z
Clicking on F will take the view and active cell to
the first cell in a column that has the letter F as the
1st character.

Thanks