Forum Discussion
Solved
Macro
I want to create macros for very simple asks. One such is to simply move the cursor down 8 rows on the spreadsheet. I can't fathom MS macro instructions (EXCEL in 365). Record macro. Fine. Dialo...
Macro recording defaults to absolute references and as such, selecting different cells without actions in between are optimized/omitted.
Switching to Relative References merely gives you what you want in this case. The possibility is there like in the old days, but not looking the same as before.
Sub Macro1() ActiveCell.Offset(8, 0).Range("A1").Select End Sub
This is a shortcoming of the macro recorder. It pays to learn a little bit about Excel VBA. The macro to move down 8 rows could look like this:
Sub MoveDown8()
ActiveCell.Offset(8).Select
End Sub