How to create a dynamic named range?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sunita - 28 Mar 2008 15:30 GMT

Hi there,
Would like to create a named range that increased when I added rows - please
assist!!
Look forward to any help.

Merci!

Reply to this Message

vezerid - 28 Mar 2008 15:38 GMT

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

> Hi there,
> Would like to create a named range that increased when I added rows - please
> assist!!
> Look forward to any help.
>
> Merci!

Reply to this Message

Sunita - 28 Mar 2008 16:15 GMT

Hello Kostis,

Your prompt response is much appreciated!!

Thanks

> 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
[quoted text clipped - 16 lines]
> >
> > Merci!

Reply to this Message

vezerid - 28 Mar 2008 20:47 GMT

Glad to be of help!

Regards

> Hello Kostis,
>
[quoted text clipped - 24 lines]
>
> - Show quoted text -

Reply to this Message