VBA code to move cursor down one cell

[Rob21030]

Any one have simple code for the end of a macro to move the cursor down one row to the cell immediately below where the macro did whatever it was supposed to do?

Thanks.

Rob

 

[Smitty]

Welcome to the Board!

Try:

ActiveCell.Offset(1).Select

But it's generally not necessary to Select objects in order to work with them, so you might want to post you code and see if we can optimize it for you.

Hope that helps,

Smitty

 

[Rob21030]

Thanks. My needs are as simple as the solution you provided. I just want to go down one and be done. In old Lotus speak a simple D (as I recall) would do the same thing.

Rob

 

[shripadlale]

I had this question as well, and this solution solved it. I wanted to write a macro to add a row BELOW the current Row. For some reason, Excel for Mac OS does not have an option of Add Below. So, I had to move down one cell, and then add a row Above. Worked like a charm! Thanks for sharing!