ExcelBanter - Down Arrow

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

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

- - Down Arrow (https://www.excelbanter.com/excel-programming/304489-down-arrow.html)

Grant Reid

Down Arrow

Hi All

How do I simulate the Down arrow keystroke in VBA? I just need the cursor to
go down one cell.

Mant Thanks - Grant

JWolf

Down Arrow

ActiveCell.Offset(1, 0).Select

Grant Reid wrote:
Hi All

How do I simulate the Down arrow keystroke in VBA? I just need the cursor to
go down one cell.

Mant Thanks - Grant

kkknie[_169_]

Down Arrow

Here's one (of many) ways...

ActiveCell.Offset(1, 0).Select

--
Message posted from http://www.ExcelForum.com

Grant Reid

Down Arrow

Hi

Thanks for the help. Much appreciated

Kind Regards - Grant

All times are GMT +1. The time now is 08:14 AM.