Named Ranges

Hello, I am naming ranges using the ThisWorkbook.Names.Add method and while
I can later view them in a list of Names when I use the command sequence
Insert Name Define, I cannot see them when I hit F5 or Control-G to 'Goto'
them. Can someone please explain what extra steps I might need to take to be
able to see them in the Goto box?

Thanks

Resolved, sorry:

I had named the ranges without the equal sign in front of the naming string,
and this caused the workbook to accept them as some other kind of Name --
for whate purpose I do not know, but I assume that is a feature -- and not
as a range.

Sorry for anyone's trouble...

"William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
news:[email protected]...
> Hello, I am naming ranges using the ThisWorkbook.Names.Add method and
> while I can later view them in a list of Names when I use the command
> sequence Insert Name Define, I cannot see them when I hit F5 or Control-G
> to 'Goto' them. Can someone please explain what extra steps I might need
> to take to be able to see them in the Goto box?
>
> Thanks
>
>

William,

What is happening here is that by omitting the = sign, you are creating a
name, but it is not referring to a range, but rather a variable. This can
be very useful as a feature for storing variables within a workbook, such as
VAT wherby you can store a VAT.

A more detailed explanation can be found at
http://www.xldynamic.com/source/xld.Names.html


--

HTH

RP
(remove nothere from the email address if mailing direct)


"William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
news:[email protected]...
> Resolved, sorry:
>
> I had named the ranges without the equal sign in front of the naming
string,
> and this caused the workbook to accept them as some other kind of Name --
> for whate purpose I do not know, but I assume that is a feature -- and not
> as a range.
>
> Sorry for anyone's trouble...
>
> "William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
> news:[email protected]...
> > Hello, I am naming ranges using the ThisWorkbook.Names.Add method and
> > while I can later view them in a list of Names when I use the command
> > sequence Insert Name Define, I cannot see them when I hit F5 or
Control-G
> > to 'Goto' them. Can someone please explain what extra steps I might need
> > to take to be able to see them in the Goto box?
> >
> > Thanks
> >
> >
>
>

Bob, thanks. I have read your article there and it is great. I plan to refer
to it until I become more comfortable with Names, I certainly see the value.





"Bob Phillips" <[email protected]> wrote in message
news:O%23eO%[email protected]...
> William,
>
> What is happening here is that by omitting the = sign, you are creating a
> name, but it is not referring to a range, but rather a variable. This can
> be very useful as a feature for storing variables within a workbook, such
> as
> VAT wherby you can store a VAT.
>
> A more detailed explanation can be found at
> http://www.xldynamic.com/source/xld.Names.html
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
> news:[email protected]...
>> Resolved, sorry:
>>
>> I had named the ranges without the equal sign in front of the naming
> string,
>> and this caused the workbook to accept them as some other kind of Name --
>> for whate purpose I do not know, but I assume that is a feature -- and
>> not
>> as a range.
>>
>> Sorry for anyone's trouble...
>>
>> "William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
>> news:[email protected]...
>> > Hello, I am naming ranges using the ThisWorkbook.Names.Add method and
>> > while I can later view them in a list of Names when I use the command
>> > sequence Insert Name Define, I cannot see them when I hit F5 or
> Control-G
>> > to 'Goto' them. Can someone please explain what extra steps I might
>> > need
>> > to take to be able to see them in the Goto box?
>> >
>> > Thanks
>> >
>> >
>>
>>
>
>

Just re-read my reply, classic phrase

a variable such as VAT whereby you can store a VAT.

Obvious or what <vbg>

--

HTH

RP
(remove nothere from the email address if mailing direct)


"William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
news:[email protected]...
> Bob, thanks. I have read your article there and it is great. I plan to
refer
> to it until I become more comfortable with Names, I certainly see the
value.
>
>
>
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:O%23eO%[email protected]...
> > William,
> >
> > What is happening here is that by omitting the = sign, you are creating
a
> > name, but it is not referring to a range, but rather a variable. This
can
> > be very useful as a feature for storing variables within a workbook,
such
> > as
> > VAT wherby you can store a VAT.
> >
> > A more detailed explanation can be found at
> > http://www.xldynamic.com/source/xld.Names.html
> >
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
> > news:[email protected]...
> >> Resolved, sorry:
> >>
> >> I had named the ranges without the equal sign in front of the naming
> > string,
> >> and this caused the workbook to accept them as some other kind of
Name --
> >> for whate purpose I do not know, but I assume that is a feature -- and
> >> not
> >> as a range.
> >>
> >> Sorry for anyone's trouble...
> >>
> >> "William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
> >> news:[email protected]...
> >> > Hello, I am naming ranges using the ThisWorkbook.Names.Add method and
> >> > while I can later view them in a list of Names when I use the command
> >> > sequence Insert Name Define, I cannot see them when I hit F5 or
> > Control-G
> >> > to 'Goto' them. Can someone please explain what extra steps I might
> >> > need
> >> > to take to be able to see them in the Goto box?
> >> >
> >> > Thanks
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Heh heh...

I learned so much from your post and your article Bob, it really was timely.
It made all the difference in the world to the project I just completed.

Using VBA to build Name formulas was a piece of cake (once I learned the
hard way that the RefersTo property is quite literal and does not share the
same conversion that VBA runs the .FormulaR1C1 through.

Thanks again!!

"Bob Phillips" <[email protected]> wrote in message
news:O%[email protected]...
> Just re-read my reply, classic phrase
>
> a variable such as VAT whereby you can store a VAT.
>
> Obvious or what <vbg>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
> news:[email protected]...
>> Bob, thanks. I have read your article there and it is great. I plan to
> refer
>> to it until I become more comfortable with Names, I certainly see the
> value.
>>
>>
>>
>>
>>
>> "Bob Phillips" <[email protected]> wrote in message
>> news:O%23eO%[email protected]...
>> > William,
>> >
>> > What is happening here is that by omitting the = sign, you are creating
> a
>> > name, but it is not referring to a range, but rather a variable. This
> can
>> > be very useful as a feature for storing variables within a workbook,
> such
>> > as
>> > VAT wherby you can store a VAT.
>> >
>> > A more detailed explanation can be found at
>> > http://www.xldynamic.com/source/xld.Names.html
>> >
>> >
>> > --
>> >
>> > HTH
>> >
>> > RP
>> > (remove nothere from the email address if mailing direct)
>> >
>> >
>> > "William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
>> > news:[email protected]...
>> >> Resolved, sorry:
>> >>
>> >> I had named the ranges without the equal sign in front of the naming
>> > string,
>> >> and this caused the workbook to accept them as some other kind of
> Name --
>> >> for whate purpose I do not know, but I assume that is a feature -- and
>> >> not
>> >> as a range.
>> >>
>> >> Sorry for anyone's trouble...
>> >>
>> >> "William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
>> >> news:[email protected]...
>> >> > Hello, I am naming ranges using the ThisWorkbook.Names.Add method
>> >> > and
>> >> > while I can later view them in a list of Names when I use the
>> >> > command
>> >> > sequence Insert Name Define, I cannot see them when I hit F5 or
>> > Control-G
>> >> > to 'Goto' them. Can someone please explain what extra steps I might
>> >> > need
>> >> > to take to be able to see them in the Goto box?
>> >> >
>> >> > Thanks
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>