rngDataAll, rngEnd, rngStart, etc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nod - 19 Sep 2007 08:02 GMT

I have come across these values rngDataAll, rngEnd, rngStart, etc used
with a range object thus:
Range("rngEnd")
It is self-evident what they mean but where are they defined?

Reply to this Message

Mike H - 19 Sep 2007 08:26 GMT

Hi,

Naming ranges can be done in a couple of ways, have a look here:-

http://www.cpearson.com/excel/named.htm

Mike

> I have come across these values rngDataAll, rngEnd, rngStart, etc used
> with a range object thus:
> Range("rngEnd")
> It is self-evident what they mean but where are they defined?

Reply to this Message

Stefi - 19 Sep 2007 08:28 GMT

Have a look at Insert/Names/Names Definition!

Regards,
Stefi

„nod” ezt írta:

> I have come across these values rngDataAll, rngEnd, rngStart, etc used
> with a range object thus:
> Range("rngEnd")
> It is self-evident what they mean but where are they defined?

Reply to this Message

noddy - 19 Sep 2007 09:06 GMT

Thank you both. That is just what I needed.

Reply to this Message