I am putting a hyperlink in a sheet to go to a range of cells, e.g.
A1:A22

However as I am working with the sheet, that range can change as I
might add content above the range or in the range.

Is there a way to make the first and last cells 'absolute' so that it
always grabs that first cell and last cell and anything in between
regardless of whether the first or last cell gets pushed down by other
content?

You could try naming the reference cells, and then point the hyperlink to the
Named Range of cells.

"cncf" wrote:

I am putting a hyperlink in a sheet to go to a range of cells, e.g.
A1:A22

However as I am working with the sheet, that range can change as I
might add content above the range or in the range.

Is there a way to make the first and last cells 'absolute' so that it
always grabs that first cell and last cell and anything in between
regardless of whether the first or last cell gets pushed down by other
content?

On Jun 2, 2:32*pm, KePaHa wrote:
You could try naming the reference cells, and then point the hyperlink to the
Named Range of cells.



"cncf" wrote:
I am putting a hyperlink in a sheet to go to a range of cells, e.g.
A1:A22

However as I am working with the sheet, that range can change as I
might add content above the range or in the range.

Is there a way to make the first and last cells 'absolute' so that it
always grabs that first cell and last cell and anything in between
regardless of whether the first or last cell gets pushed down by other
content?- Hide quoted text -

- Show quoted text -

Awesome, perfect!

Thanks

On Jun 2, 2:32*pm, KePaHa wrote:
You could try naming the reference cells, and then point the hyperlink to the
Named Range of cells.



"cncf" wrote:
I am putting a hyperlink in a sheet to go to a range of cells, e.g.
A1:A22

However as I am working with the sheet, that range can change as I
might add content above the range or in the range.

Is there a way to make the first and last cells 'absolute' so that it
always grabs that first cell and last cell and anything in between
regardless of whether the first or last cell gets pushed down by other
content?- Hide quoted text -

- Show quoted text -

So for a related question since i can't find this either :) is there a
way to lock one cell to another in terms of positional relationship? I
named the ranges, the first cell has one to the left of it at all
times so if I add more cells in the right colum the ranges work now
but the left cells don't 'move' with them. Is this possible?

Not that I know of, but perhaps someone else in here will have an idea.

"cncf" wrote:
So for a related question since i can't find this either :) is there a
way to lock one cell to another in terms of positional relationship? I
named the ranges, the first cell has one to the left of it at all
times so if I add more cells in the right colum the ranges work now
but the left cells don't 'move' with them. Is this possible?