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

ActiveCell.End(xldown).Select

--
Regards,
Tom Ogilvy


"praveen_khm"
wrote in message
...

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

Thanks Tom :)


--
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