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...)