range("myrng"), names("myrng").RefersToRange??

  • Thread starter Thread starter active_x
  • Start date Start date
A

active_x

Any difference between 'range("myrng")' and 'names
("myrng").RefersToRange'??

(in general, when "myrng" = UNCOMBINED cells, when "myrng" = COMBINED cells...)
 
Range is an object, so you get back an the range object that 'myRng' refers
to, whereas Names...Refersto returns a string that shows the referred to
value, including the leading -.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

active_x said:
Any difference between 'range("myrng")' and 'names
("myrng").RefersToRange'??

(in general, when "myrng" = UNCOMBINED cells, when "myrng" = COMBINED
Click to expand...
cells...)
 
Believe Bob was talking about the Refersto property of the name.

Both

Range("myRange")
and
Names("MyRange").ReferesToRange

should return the same range

--
Regards,
Tom Ogilvy

active_x said:
Any difference between 'range("myrng")' and 'names
("myrng").RefersToRange'??

(in general, when "myrng" = UNCOMBINED cells, when "myrng" = COMBINED
Click to expand...
cells...)
 
Back
Top