Hi,

i have created a Named Range, and entered the following formula in "Refers To:"

=offset(Customers!$C$6,,,Counta(Customers!$C$6:$C$103),6)

the formula is rejected ??
I am using 2010
any help would be appreciated
Thank you in advance!