ExcelBanter - simulate down arrow

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - simulate down arrow (https://www.excelbanter.com/excel-programming/373846-simulate-down-arrow.html)

Geebee

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

Die_Another_Day

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

All times are GMT +1. The time now is 04:43 PM.