Not necessary with a defined name range as already suggested.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"challa prabhu" wrote in message
...
Hi,

Assuming that you have a range containing two rows and two columns and
you
have named the range as DATA. Now when you add rows or columns, you must
add
those columns and Rows within the named range.

This way the "Refer to:" text box, in the Define Name dialog will
automatically take the relative refernce of your modified cell range.

Challa Prabhu

"M&M" wrote:

Hi, I have a named range in which I have some values. However this range
will
be changing all the time. Maybe will increase in number of colums and
rows
maybe decrease depending on the inputs of the user.

How can I make it so that the range remains named "Data" and changes in
size
when the user inputs values?