Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default simulate down arrow

hi,

I have the following..
Range(Selection, Selection.xlDown).Select

But I just want to simulate hitting the down arrow key, to select the second
row in the current column.

Thanks in advance,
geebee

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 644
Default simulate down arrow

ActiveCell.Offset(1).Select

HTH
Charles Chickering
geebee wrote:
hi,

I have the following..
Range(Selection, Selection.xlDown).Select

But I just want to simulate hitting the down arrow key, to select the second
row in the current column.

Thanks in advance,
geebee


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simulate Check Box Karen Excel Discussion (Misc queries) 15 April 27th 09 06:34 PM
Excel 2007 - Macro (VB) code for arrow down & arrow up Grindy Excel Discussion (Misc queries) 5 January 28th 09 04:30 AM
why dont shift+arrow or ctrl+arrow work in 2007 Naguib Excel Discussion (Misc queries) 1 July 24th 07 04:40 PM
Macro to Simulate F2 Lil Pun Excel Programming 7 April 25th 06 11:06 PM
simulate a enter key behaviour? Liedson31 Excel Programming 2 June 17th 05 02:52 PM


All times are GMT +1. The time now is 02:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"