GOTO error reading cell ADDRESS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've run out of ways to try to get the cursor to highlight a particluar cell that is defined by the contents of a different cell. In other words, I want to GOTO the cell that is named in another cell in which the destination cell is identified. The destination cell addresses will change regularly and I'd like to simply get there by referring to the contents of a fixed cell in a Ctrl+G GOTO reference. I can't get the GOTO function to read the cell identified without an invalid reference error message. I've tried to use ADDRESS, TEXT and other functions within the reference area with similar results. Any ideas??
 
one way:

Say the cell that contains your reference is cell J1 on sheet 1.

Choose Insert/Name/Define and enter a name, say "MyGo" and in the refers
to box, enter

=INDIRECT(Sheet1!$J$1)

and click Add.

Now, if cell J1 contains "X47", then type Ctrl-g and enter MyGo in the
goto box (Note: you have to type it, it won't appear in the listbox).
You'll then see the selection go to X47.
 
That does the trick!! Thanks for your insight

----- JE McGimpsey wrote: -----

one way:

Say the cell that contains your reference is cell J1 on sheet 1.

Choose Insert/Name/Define and enter a name, say "MyGo" and in the refers
to box, enter

=INDIRECT(Sheet1!$J$1)

and click Add.

Now, if cell J1 contains "X47", then type Ctrl-g and enter MyGo in the
goto box (Note: you have to type it, it won't appear in the listbox).
You'll then see the selection go to X47.
 
Back
Top