Prev: Drop Down with hidden values
Next: When this NG migrates to forums, please consider ...
From: Ken Warthen on 7 Jun 2010 13:34
In an Excel 2010 workbook I created a dynamic named range from the Formula
tab using the Define Name utility. The formula I entered is:

=OFFSET(Price Groups!$AP$2,0,0,COUNTA(Price Groups!$AP:$AP)-1,1)

I want the range to include all non-empty cells in the AP column starting
with the second row. When I check the named range using the Name Manager it
shows the formula:

=OFFSET(Price Groups!$AP$2,0,0,COUNTA(Price Groups!$AP$1:$AP$65536)-1,1)

I'm not sure why Excel converts my formula, but I've tried several time to
change it back to my formula and each time I get the same result. If anyone
know what I'm doing wrong here, I'd appreciate any offered advice.

TIA,

Ken
From: Don Guillett on 7 Jun 2010 17:03
Try PriceGroups as ONE word

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Ken Warthen" <KenWarthen(a)discussions.microsoft.com> wrote in message
news:6B6E3EEA-6A70-436C-81E6-5EF34BE70B75(a)microsoft.com...
> In an Excel 2010 workbook I created a dynamic named range from the Formula
> tab using the Define Name utility. The formula I entered is:
>
> =OFFSET(Price Groups!$AP$2,0,0,COUNTA(Price Groups!$AP:$AP)-1,1)
>
> I want the range to include all non-empty cells in the AP column starting
> with the second row. When I check the named range using the Name Manager
> it
> shows the formula:
>
> =OFFSET(Price Groups!$AP$2,0,0,COUNTA(Price Groups!$AP$1:$AP$65536)-1,1)
>
> I'm not sure why Excel converts my formula, but I've tried several time to
> change it back to my formula and each time I get the same result. If
> anyone
> know what I'm doing wrong here, I'd appreciate any offered advice.
>
> TIA,
>
> Ken

From: Ken Warthen on 7 Jun 2010 18:47
Don,

Thanks for the advice, but the worksheet name is Price Groups (with a space
between Price and Groups). The worksheet name is used througout the project
so it's not something I can easily change.

Ken

"Don Guillett" wrote:

> Try PriceGroups as ONE word
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett(a)gmail.com
> "Ken Warthen" <KenWarthen(a)discussions.microsoft.com> wrote in message
> news:6B6E3EEA-6A70-436C-81E6-5EF34BE70B75(a)microsoft.com...
> > In an Excel 2010 workbook I created a dynamic named range from the Formula
> > tab using the Define Name utility. The formula I entered is:
> >
> > =OFFSET(Price Groups!$AP$2,0,0,COUNTA(Price Groups!$AP:$AP)-1,1)
> >
> > I want the range to include all non-empty cells in the AP column starting
> > with the second row. When I check the named range using the Name Manager
> > it
> > shows the formula:
> >
> > =OFFSET(Price Groups!$AP$2,0,0,COUNTA(Price Groups!$AP$1:$AP$65536)-1,1)
> >
> > I'm not sure why Excel converts my formula, but I've tried several time to
> > change it back to my formula and each time I get the same result. If
> > anyone
> > know what I'm doing wrong here, I'd appreciate any offered advice.
> >
> > TIA,
> >
> > Ken
>
> .
>
 | 
Pages: 1
Prev: Drop Down with hidden values
Next: When this NG migrates to forums, please consider ...