Hi all,

The following formula i use to name a range so when ever i add data to
column A the range is automatically adjusted.

=OFFSET(Daily!$A$1,1,0,COUNTA(Daily!$A:$A)-1)

now how I cud I modify this formula to get a dynamic range on Row 1
($1:$1)

thanks

=OFFSET(Daily!$A$1,0,0,1,COUNTA(Daily!$1:$1))

If you want to make adjustments such as in your column example where you
start in A2, then you can apply those as well.


=OFFSET(Daily!$A$1,0,1,1,COUNTA(Daily!$1:$1)-1)
would start in B1 for example. (and assumes A1 contains a value)
--
Regards,
Tom Ogilvy


"Abdul" wrote:

Hi all,

The following formula i use to name a range so when ever i add data to
column A the range is automatically adjusted.

=OFFSET(Daily!$A$1,1,0,COUNTA(Daily!$A:$A)-1)

now how I cud I modify this formula to get a dynamic range on Row 1
($1:$1)

thanks

=OFFSET(Daily!$A$1,0,0,1,COUNTA(Daily!$1:$1)-1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Abdul" wrote in message
ups.com...
Hi all,

The following formula i use to name a range so when ever i add data to
column A the range is automatically adjusted.

=OFFSET(Daily!$A$1,1,0,COUNTA(Daily!$A:$A)-1)

now how I cud I modify this formula to get a dynamic range on Row 1
($1:$1)

thanks