Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges
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" wrote in message ... 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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Programming | |||
named ranges - changing ranges with month selected | Excel Programming | |||
Named ranges | Excel Programming | |||
Named Ranges | Excel Programming |