Forum Discussion
Larry1265
Jan 22, 2022Copper Contributor
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...
- Jan 23, 2022
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
Larry1265
Jan 23, 2022Copper Contributor
bosinander
Jan 24, 2022Iron Contributor
You're welcome 🙂