How to define name range in vba

[HaroonSid]

hi,

i want to know here about this line

Please Login or Register  to view this content.

what is the meaning of above code

[LJMetzger]

Hi,

See the annotated macro below for an explanation.

Please Login or Register  to view this content.

Lewis

[JBeaucaire]

The .RefersTo is a parameter of the .Name property of a range. However if you look at the named range properties in the Name Wizard, you'll see it always includes an = sign at the beginning:

=Sheet1!$C$2:$C$19

The MID function in your code simply stripping off that = sign to show just the range as a text string:

Sheet1!$C$2:$C$19

[HaroonSid]

Thanx sir for replying, I have a code and I am getting error. But I can't sort out the error.
Will u plz look?

first i tell u what is the main work of this code.

when i add some data (text or number) in Range c10:c500, then it looks in Names("ABD") and Names("NAME_SID9"), if same data found in those two names.range then it does nothing. if not found then it add the same data in boths names.ranges.

not what is the main problem?

Please Login or Register  to view this content.

its working properly.
now what is the problem, the problem is in name range ("NAME_SID9"), if this range have already data till row 99, it working properly, if it has already data above row 100,

then its giving me a error
Run-Time Error '438'
object doesn't support this property or method.


now thats the problem