This is possible to achieve with a little API code but you would not want to do that, it will be a continuously running loop to keep the x and y coordinates updated with every mouse move. Also, range A1 and A2's x and y coordinates, as is the case with any cell on the grid, would depend on the row height and column width of those cells, meaning if you widen or narrow column or column 2, or increase or decrease the row height of row 1, then you'd need to update your macro by hard-coding those coordinates after you determine what they are again.
Instead, stick a label control from the active x control toolbox onto range A1:A2. You can use the fill handles with yoru other hand on the Alt key to "snap" the lable into place so it fits perfectly inside that 2-cell range. In the Properties window, delete the caption and set the BackStyle to transparent.
Doubleclick on the Label, which will take you to the woksheet module, and paste in
Private Sub Label1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Range("D4").Select 'modify for where you want to go
Press Alt+Q to return to the worksheet.
Exit Design Mode, there is an icon for that on the control toolbox.
Now when you mouse over A1 and A2, the cells will appear normal but cell D4 will become active.