Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
nod nod is offline
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,501
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,646
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default rngDataAll, rngEnd, rngStart, etc

Thank you both. That is just what I needed.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"