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

G

Gord Dibben

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 <[email protected]> wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coding to choose the previous completed cell in a column 5
How do I write a macro to increase the value of any cell by 1? 2
Need assistance with secondary axis in Excel 2007 0
need macro: erase the last 10 digits of active cell then down 1 2
when exiting combobox, this code moves the selected cell down two rows instead of one 0
Copy a cell from a previous worksheet using a macro 7
How to modify a Word macro written for Windows so that will work on MAC 0
how do I import an excel file into quicken? 0

Top