Say your data start from 'Sheet1'!A5 and rows are added below. The
following dynamic range will be correct if you do not have any other
above A5:

=OFFSET('Sheet1'!$A$5,0,0,COUNTA('Sheet1'!$A:$A),)

Insert|Name|Define...

Enter the name for your dynamic range and then, in Refers to: enter
the above formula or its modification.

HTH
Kostis Vezerides

On Mar 28, 4:30*pm, Sunita wrote:
Hi there,
Would like to create a named range that increased when I added rows - please
assist!!
Look forward to any help.

Merci!