Try using the offset function. Sorry I don't have time to give you the
full function you need.

"XXL User" wrote:


Hi

I've got a table A1:Y147 where A1:Y1 are the field headings and D1 =
"Student ID". What I want to be able to do is to name the range of
cells from A1:Y*, where * is the last row where student ID data is
found. This should be dynamic, constantly updating upon closing the
file, so that the named range increases or decreases according to the
increasing and decreasing size of the student id column.

Can anyone help? Thanks.




--
XXL User