I want to click on a cell and for it to take me where the formula is coming from

Hello,

Please help me in solving this issue. I forgot what I need to do so that when I click on a cell that has the formula =D2900 it takes me to cell D2900. I am trying to avoid scrolling up and down, that will take me all day. I appreciate your help.

Thank you,
Eliana

Press F5, type your address in the Reference box

This bit of code should do the job...

Please Login or Register  to view this content.

It needs to be inserted correctly to work ...

With the workbook you want this code to work on open (and it will be easier if only that workbook is open):

1. Press Alt-F11 to open the VB editor
2. The sheets of the workbook will be listed on the left, double-click on the sheet you want to apply this code to - a blank text editor will open.
3. In the drop-down at the top left of the editor select "Worksheet"
4. The first and last lines of my code will appear automatically, paste the rest of the code in between them.
5. Close the VB editor by pressing the red cross at the top-right.
6. Sorted.

Thank you for your quick response, this helped a lot. =) Happy Holidays.

Originally Posted by djapigo

Press F5, type your address in the Reference box

Thank you, Happy Holidays. =)