Create List of Range Names by Sheet on a Second Sheet

[Vamphyri]

Happy Friday!!!

Is it possible to create a list of Range Names that is broken out by Sheet? ie..

Sheet 1 Names Sheet 2 Names Sheet 3 Names
Range Name S1-1 Range Name S2-1 Range Name S3-1
Range Name S1-2 Range Name S2-2 Range Name S3-2
Range Name S1-3 Range Name S3-3
Range Name S1-4

Many a "pro-active" thanks for any help.


In the immortal words of Socrates, who said:
"I drank what?

 

[Vamphyri]

Skip,

Please excuse my being obtuse.

NAME BOX
AGC_HNO_A15_2000_2_2000_2006

REFERS TO
AGC - HNO (A15-2000-2-2000)

Is this the info you need?


In the immortal words of Socrates, who said:
"I drank what?

 

[SkipVought]

is there no cell reference?
[tt]
REFERS TO
AGC - HNO (A15-2000-2-2000)
[/tt]

Skip,

_[red][/red]

 

[Vamphyri]

='AGC HNO Plans 2006'!$O$2:$Q$39


In the immortal words of Socrates, who said:
"I drank what?

 

[SkipVought]

I have no idea. It works for me.

Can you step thru the code and observe what is happening?

Skip,

_[red][/red]

 

[Vamphyri]

So far... Nada.

Is it possible to use a differnt bit of coding to cut/paste the long list into several smaller ones?

Just a thought.


In the immortal words of Socrates, who said:
"I drank what?

 

[SkipVought]

I did not ask a YES/NO question.

What happens when you step thru the code?

The answer is NOT nada.

Skip,

_[red][/red]

 

[SkipVought]

send your wb, I'll take a look

chichigp311 at yahoo dot com

Skip,

_[red][/red]

 

[Vamphyri]

Skip,

I sent you the WB last week.

Have I totally gone about this the wrong way or what?

Thanks


In the immortal words of Socrates, who said:
"I drank what?

 

[SkipVought]

Sorry, I have not seen it. I'll check on it later.

Skip,

_[red][/red]

 

[Vamphyri]

Skip,

Just wondering if you had any time to look at the WB I sent to you.

I can only assume I have something incorrect on my WSs for your code to NOT work.

Any help would be geatly appreciated.

Thanks

Chris


In the immortal words of Socrates, who said:
"I drank what?