ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   rngDataAll, rngEnd, rngStart, etc (https://www.excelbanter.com/new-users-excel/158858-rngdataall-rngend-rngstart-etc.html)

nod

rngDataAll, rngEnd, rngStart, etc
 
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?

Mike H

rngDataAll, rngEnd, rngStart, etc
 
Hi,

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

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

Mike

"nod" wrote:

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?


Stefi

rngDataAll, rngEnd, rngStart, etc
 
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?


noddy

rngDataAll, rngEnd, rngStart, etc
 
Thank you both. That is just what I needed.


All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com