I have noticed that when I test to see if a cell has a
named range i.e. if the name was based on Sheet$A$1 and I
use sName = rng.Name.Name I would pass the name to the
variable sName

However, this doesn't always pick it up if the named
range is say Sheet$A$1:$A$1.


Why is this?

I'm not sure you're gonna get a good answer to your "why" question--except for
that's the way excel works.

But why would you choose to define a name so that it looks like it might be a
multiple cell range?

(There's a better chance I'll get an answer from you, than you getting an answer
from MS!)

ExcelMonkey wrote:

I have noticed that when I test to see if a cell has a
named range i.e. if the name was based on Sheet$A$1 and I
use sName = rng.Name.Name I would pass the name to the
variable sName

However, this doesn't always pick it up if the named
range is say Sheet$A$1:$A$1.

Why is this?

--

Dave Peterson