Code for Arrow keys

[praveen_khm]

Hi,

Can anyone tell me the code for the arrow keys.
i.e, If i need to move the arrow key, what is the code generated.

To be more clear, I create a macro, when I use the arrow down key, it
selects the cell like "A2" (In the code it selects the physical
location as A2). I do not want that. Suppose I use a down arrow key, it
should not select the cell but as well should take anything below the
specified cell. (This is to be used when cell is not clear while
programming.)

So, clearly, I need the code for the arrow keys.

This is the code which I get when used down arrow key.

Sub Pravi()
Range("A2").Select
End Sub


Please help.
Thanks,
Praveen.

 

[Tom Ogilvy]

ActiveCell.End(xldown).Select

--
Regards,
Tom Ogilvy


"praveen_khm" <[email protected]>
wrote in message
news[email protected]...

 

[praveen_khm]

Thanks Tom