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?