names.add does not list those names in the "Go to" dialog box

  • Thread starter Thread starter sisifus
  • Start date Start date
S

sisifus

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
 
different "names".
a named range in vba does not become a defined name in the worksheet.
:)
susan
 
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
Click to expand...

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.
 
Back
Top