Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
names.add does not list those names in the "Go to" dialog box
Hi
I am adding names for ranges in VBA. For whatever reason they do not show up in the "go to.." dialog box (<ctrl<g). they are there.. I can type in the name in the dialogbox, press enter and it selects the proper range... any ideas? Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
names.add does not list those names in the "Go to" dialog box
different "names".
a named range in vba does not become a defined name in the worksheet. :) susan n Apr 3, 10:36 am, "sisifus" wrote: Hi I am adding names for ranges in VBA. For whatever reason they do not show up in the "go to.." dialog box (<ctrl<g). they are there.. I can type in the name in the dialogbox, press enter and it selects the proper range... any ideas? Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
names.add does not list those names in the "Go to" dialog box
On Apr 3, 9:36 am, "sisifus" wrote:
Hi I am adding names for ranges in VBA. For whatever reason they do not show up in the "go to.." dialog box (<ctrl<g). they are there.. I can type in the name in the dialogbox, press enter and it selects the proper range... any ideas? Michael You can add ranges to a worksheet with the following code ActiveWorkbook.Names.Add Name:="my_rng", _ RefersToR1C1:="=R47C5:R47C28" '<== change this to suit your needs. I've also had the problem where I need to repeat this code to get it to stick. I haven't ever asked why that is, but just gone along with it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete All Names - Even Invalid "#REF" Names | Excel Programming | |||
Response to "Can I get a list of names of all the tabs..." | Excel Discussion (Misc queries) | |||
Help,, need macro to replace 'space' in list of names with "." (dot), then compare ss | Excel Programming | |||
How do I list a folder of "Excel file's names" to an Excel spdsht | Excel Discussion (Misc queries) | |||
Backup to specific folder if workbook names begins with "NSR" or "MAC" | Excel Programming |