so are you leaving the cells blank to keep the range dynamic, and are going to add to it later?
edit: the reason i'm asking is i do something similar with my data validation lists. i like a tightly packed list. but i also like having the option w/in the list to choose a blank option (for whatever). so at the end of the actual list is where i store my blank cell.
so, let's say data from a1 : a50, a51 is blank, namedRange=a1:a51
when i need to add to that list, just click on a51 and insert. you could always write some code to do this for you and assign a button or something.
anyway, i hope this helps. i'll check in the morn. good luck Brian.