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]...
>
> 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.
>
>
> --
> praveen_khm
> ------------------------------------------------------------------------
> praveen_khm's Profile:
http://www.excelforum.com/member.php...o&userid=30364
> View this thread: http://www.excelforum.com/showthread...hreadid=504579
>

[praveen_khm]

Thanks Tom