Urgent! Named range scope


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
 
Ad

Advertisements

R

Rick Rothstein

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#.
 
Ad

Advertisements

J

Jim Rech

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top