Forum Discussion

Larry1265's avatar
Larry1265
Copper Contributor
Jan 22, 2022
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...
Macros and VBA
  • bosinander's avatar
    bosinander
    Jan 23, 2022

    Larry1265 

    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

     

NowshadAhmed's avatar
NowshadAhmed
Iron Contributor
Jan 23, 2022

Perhaps when recording the Macro, you are not selecting the cell 8 rows below?
Excel Macro doesn't record mouse cursor movements.

 

EDIT: It seems the macro record is specific and not dynamic. So even if you record successfully, it will always move to the last cell you selected before stopping the record:

 

Best Solution is what HansVogelaar observed.

Resources