how to keep a range relevant

You probably need a dynamic named range and use that in the formulae elsewhere that reference it.

There's a good tutorial here: http://www.contextures.com/xlNames01.html

By the way, it is usually better to attach a workbook rather than an image.

Thanks AliGW.

It seems the solution is to select the entire range, name it, then enter this formula in the refers to section: =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)

I notice it says A:A. Does this mean I cant put anything in col A after a few blank rows? I cant be sure I'll never use a certain column again.

EDIT - I tried this. I'm assuming the first 0 is the number of rows and the second is the number of columns. But when I created this, although it showed up in Name Manager, it didn't show up in the Name Shortcut thing at the top left, just left of the formula bar. So I cant seem to test whether this is even looking at the right place. When I goto Name Manager I cant seem to direct it to highlight the correct range.

And for some reason Name Manager seems to have hundreds of entries. None of them show up in the Name Box / Shortcut. In Name Manager the first 3 entries are "\A" (without the quotes). Then there's \C three times. What gives?