More Hyperlink Cell 'Relative' Questions

[cncf]

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?

 

[KePaHa]

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

 

[cncf]

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







- Show quoted text -

Awesome, perfect!

Thanks

 

[cncf]

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







- 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?

 

[KePaHa]

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