You can create a dynamic named range using OFFSET() and COUNTA(). Check out
the below article

http://support.microsoft.com/kb/830287

If this post helps click Yes
---------------
Jacob Skaria


"Vanya" wrote:

I have a named data range that is referenced in other worksheets within a
workbook. The master list of data needs to be expandable for the user which
means that I need to have the data range expand as the user adds rows to the
data range through an input form. Is this possible? The user is not
computer knowledgeable. It would be ideal to have the user be able to add or
remove data from the range of master data resulting in the size of the range
adjusting AND automatically "re-sorting" according to original set criteria,
which is simple (Text - A-Z in one of the 7 columns)