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
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
- You're welcome 🙂