Macro to move focus after entry in a cell

[Phil H]

Two ranges: D7:G57 and J7:M57

Any time an entry is made in a G cell, focus returns to the next lower D cell. Same for M entries – focus moves to the next lower J cell. For example: When an entry is made in G35, the active cell (focus) changes to D36.



However, when an entry is made in G57 (or M57), the last cell in the range, this rule does not apply – the active cell remains G57 (or M57).