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?