Thread: [Solved] Macro to move focus after entry in a cell
View Single Post
 
Old 06-18-2015, 06:41 AM
Phil H Phil H is offline Windows XP Office 2003
Advanced Beginner
  
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default Macro to move focus after entry in a cell
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).
Reply With Quote