Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2006

Tip: Looking for answers? Try searching our database.

Code for Arrow keys

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
praveen_khm - 24 Jan 2006 18:30 GMT
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.

Signature

praveen_khm

Tom Ogilvy - 24 Jan 2006 18:50 GMT
ActiveCell.End(xldown).Select

Signature

Regards,
Tom Ogilvy

> Hi, :)
>
[quoted text clipped - 19 lines]
> Thanks,
> Praveen.
praveen_khm - 24 Jan 2006 18:59 GMT
Thanks Tom :)

Signature

praveen_khm

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.