Go to from reference in VBA code to actual cell?
 

When looking at VBA code, is there a quick way (shortcut key) to go to a
cell which is referenced in the code?

John Dalberg

Go to from reference in VBA code to actual cell?
 

If you are wanting to see the value of the cell, you can use the
Immediate window by pressing Ctrl+G then type "?Range("A1").Formula"
(without quotes) and press enter

Charles
John Dalberg wrote:
When looking at VBA code, is there a quick way (shortcut key) to go to a
cell which is referenced in the code?

John Dalberg

Go to from reference in VBA code to actual cell?
 

resize the VBE and give Excel/VBE each half a screen. then you can maneuver
in the Excel side of the screen

An alternative would be to build your own COM addin that supports this
functionality.

--
Regards,
Tom Ogilvy


"John Dalberg" wrote:

When looking at VBA code, is there a quick way (shortcut key) to go to a
cell which is referenced in the code?

John Dalberg

Go to from reference in VBA code to actual cell?
 

?B?VG9tIE9naWx2eQ==?= wrote:
resize the VBE and give Excel/VBE each half a screen. then you can
maneuver in the Excel side of the screen

The whole idea for my request is so that I don't have to do this and make
it as painless as possible.


An alternative would be to build your own COM addin that supports this
functionality.

I am not a COM developer. Is there anything downloadable out there?

John Dalberg

Go to from reference in VBA code to actual cell?
 

"Die_Another_Day" wrote:
If you are wanting to see the value of the cell, you can use the
Immediate window by pressing Ctrl+G then type "?Range("A1").Formula"
(without quotes) and press enter

Actually I want it to be more visual and want to see where it resides in
the worksheet, doing this will give me the formula and the value.


John Dalberg wrote:
When looking at VBA code, is there a quick way (shortcut key) to go to
a cell which is referenced in the code?

John Dalberg

Go to from reference in VBA code to actual cell?
 

John,
Not sure if it's what you are looking for, but the Locals window
(ViewLocal) gives you the info on the current variables/objects

NickHK

"John Dalberg" ...
?B?VG9tIE9naWx2eQ==?= wrote:
resize the VBE and give Excel/VBE each half a screen. then you can
maneuver in the Excel side of the screen

The whole idea for my request is so that I don't have to do this and make
it as painless as possible.


An alternative would be to build your own COM addin that supports this
functionality.

I am not a COM developer. Is there anything downloadable out there?

John Dalberg