Urgent! Named range scope

  • Thread starter Thread starter Jorge Ribeiro
  • Start date Start date
J

Jorge Ribeiro

Hello

I've an excel app written in c#
How can I check the scope of a name range?!

ie: i've a range name ABC with scope Sheet1 and another ABC with scope
Workbook

How can i check the scope of a range?

it's urgent... it's slowing me down

best regards

Jorge
 
I don't use C#, so I can't help you with your syntax, but in VBA (the
language this newsgroup usually caters to) you would reference the range
like this...

Worksheets("Sheet1").Range("ABC")

where the sheet name and range name are specified as String arguments to the
Worksheet and Range properties... perhaps this will help you in translating
it into C#.
 
A local name in Excel has an exclamation point as part of it, e.g.,
Sheet1!RgName.

In VBA, this: Range("RgName").Name.Name

returns: Sheet1!RgName

So I'd look for the "!" in the Name.Name property.

--
Jim
| Hello
|
| I've an excel app written in c#
| How can I check the scope of a name range?!
|
| ie: i've a range name ABC with scope Sheet1 and another ABC with scope
| Workbook
|
| How can i check the scope of a range?
|
| it's urgent... it's slowing me down
|
| best regards
|
| Jorge
 
Back
Top