Scroll to cell (Second cell) Alt + [

[jakobt]

Have a cell(A1) with a formula consisting of two cells:

+B1+B2

If selecting cell A1 and typing Alt+[ I get directed to cell B1. Is there any way (Shortcut) to be directed to the second cell instead?

 

[James006]

Hello,

Based on your simple example ...

You could test the following macro :

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
' Just Double-Click on Source cell
Dim a As Variant
a = Split(Replace(Target.Formula, "=", ""), "+")
Application.Goto Range(a(1))
MsgBox Range(a(1)).Value
Cancel = True
End Sub

Hope this will help

 

[James006]

Hello,

Once you have tested the macro ...

Feel free to share your comments ...