ExcelBanter - how do I set up a macro that will move the cursor down one cell?

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

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

- - how do I set up a macro that will move the cursor down one cell? (https://www.excelbanter.com/excel-programming/377566-how-do-i-set-up-macro-will-move-cursor-down-one-cell.html)

how do I set up a macro that will move the cursor down one cell?

Gord Dibben

how do I set up a macro that will move the cursor down one cell?

Sub downer()
ActiveCell.Offset(1, 0).Select
End Sub

Sub downer2()
ActiveCell.Offset(1, 0).Interior.ColorIndex = 3
End Sub

Gord Dibben MS Excel MVP

On Thu, 16 Nov 2006 15:52:01 -0800, gk wrote:

how do I set up a macro that will move the cursor down one cel

thank you.

"Gord Dibben" wrote:

Sub downer()
ActiveCell.Offset(1, 0).Select
End Sub

Sub downer2()
ActiveCell.Offset(1, 0).Interior.ColorIndex = 3
End Sub

Gord Dibben MS Excel MVP

On Thu, 16 Nov 2006 15:52:01 -0800, gk wrote:

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