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

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

(in general, when "myrng" = UNCOMBINED cells, when "myrng" = COMBINED cells...)

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

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" wrote in message
om...
Any difference between 'range("myrng")' and 'names
("myrng").RefersToRange'??

(in general, when "myrng" = UNCOMBINED cells, when "myrng" = COMBINED
cells...)

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

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 wrote in message
om...
Any difference between 'range("myrng")' and 'names
("myrng").RefersToRange'??

(in general, when "myrng" = UNCOMBINED cells, when "myrng" = COMBINED
cells...)