How to program a key, say F4?

[Jonathan Lee]

I have a huge spreadsheet in Excel 2002 and needs to jump from predefined
rows alot. I would like to know if there is a way to program a key, say F4,
so the cursor box will go all the way to the row 1 of the spread sheet.



Secondly, is there a way to program that key so it will jump to row 2000 and
then row 10000? Thanks.

 

[Chip Pearson]

Jonathan,

First, create macros that will do what you want to do. Then, assign those
macros to function keys using the OnKey method. E.g.,

Sub GoToRow1()
Application.Goto ActiveCell.EntireColumn.Cells(1, 1), True
End Sub

Sub InitKey()
Application.OnKey "{F4}","GoToRow1"
End Sub

 

[light_wt]

Thanks Chip. I'll try that.

Jon.