011 at 3:21 AM, hanumant shinde
> wrote:
>
>> Hi Sam,
>>
>> Thanks it worked.
>>
>>
>> --
>> *From:* Sam Mathai Chacko
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Friday, 4 November 2011 12:02 AM
>&g
> *To:* excel-macros@googlegroups.com
> *Sent:* Friday, 4 November 2011 12:02 AM
> *Subject:* Re: $$Excel-Macros$$ Determine scope of name range
>
> Sub NameInMe()
>
> Dim nm As Name
>
> For Each nm In ThisWorkbook.Names
> If nm.Parent.Name
Hi Sam,
Thanks it worked.
>
>From: Sam Mathai Chacko
>To: excel-macros@googlegroups.com
>Sent: Friday, 4 November 2011 12:02 AM
>Subject: Re: $$Excel-Macros$$ Determine scope of name range
>
>
>Sub NameInMe()
>
> Dim nm As
Pls give an example of “scope”
Don Guillett
SalesAid Software
dguille...@gmail.com
From: hanumant shinde
Sent: Thursday, November 03, 2011 12:28 PM
To: Excel Group
Subject: $$Excel-Macros$$ Determine scope of name range
Hi Friends,
i need to find out scope of the name range i.e. if the
Sub NameInMe()
Dim nm As Name
For Each nm In ThisWorkbook.Names
If nm.Parent.Name = ThisWorkbook.Name Then
MsgBox nm.Name & " is workbook level"
Else
MsgBox nm.Name & " is sheet level"
End If
Next
End Sub
Regards,
Sam Mathai Chacko
O
Hi Friends,
i need to find out scope of the name range i.e. if the defined name is has a
scope of worksheet or workbook.
below is my code
sub test
dim namerange as name
for each nameange in thisworkbook.names
a = namerange.name
'here i want to find out th scope of the name range.
lets say
