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?

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?

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?

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?

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?

Since A5 has 35400,
Define BOTTOM as 'refers to;
A1
Enter this in A1
="A" & $A$5
so that you get A35400.
Insert Hyperlink referring to BOTTOM
Now redefine BOTTOM as 'refers to;
=INDIRECT(A1)
[For a reason I do not understand, BOTTOM does not show up in Hyperlink
dialog if it has INIRECT formula... Hyperlink works if you change the formula
for BOTTOM later]

with A1 as
"rhhince" wrote:

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?