I did exactly that. A1 formula is: =INDIRECT("A"&$A$5). The formula in
A5 counts the rows in use. I defined the name as BOTTOM. Cell A1 gave
me 35400. Just below that A2 is a hyperlink referencing BOTTOM. When I
press the hyperlink it directs me to cell A1, not cell A35400 which is
the goal. Probably getting closer. Thanks again.


On Apr 24, 1:36*am, Sheeloo wrote:
That is what it will do if the formula in A1 evaluates to A12000

"rhhince" wrote:
That worked out, but I was not entirely clear on the description of
the problem. I want to reference row 12000 and go there when I press
the hyperlink. Thanks for that help though.

On Apr 23, 7:55 pm, Sheeloo wrote:
In A1 enter a formula which results in a string like
A11000 or whatever the last cell is
Define a name (INSERT-NAME_DEFINE, say, LASTCELL as
=INDIRECT(A1)

Now insert a hyperlink, in A2, to
LASTCELL

"rhhince" wrote:
I have a number in cell A1 that counts the rows in use, say 11000.
I have a hyperlink that I use to go to the bottom of the spreasheet in
cell A2 to reference row 11000.
However, every time I paste data cell A1 changes to read 12000. In
order to reference row 12000, I must change the hyperlink info
manually. Is there a simple code to automatically change the hyperlink
to reference row 12000?