Scroll to cell (Second cell) Alt + [

jakobt

Active Member
Joined
May 31, 2010
Messages
306
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?
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

Based on your simple example ...

You could test the following macro :

Code:
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

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

Once you have tested the macro ...

Feel free to share your comments ...
 

Watch MrExcel Video

Forum statistics

Threads
1,108,992
Messages
5,526,109
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top