Try Debra's page at:
http://www.contextures.com/xlNames01.html#Dynamic
Create a Dynamic Range
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Asiageek" wrote:
I have a list of data that was given a name to an area of data though I've
added more data (rows) and the list doesn't work with the new data added and
reverts back to the original named list regardless of row additions anywhere.

How do I change the range of data named to cover the extra data/rows added?
i can't seem to find the right information about this.

Thank you.