active cell list name

[Hippy]

Is there a way to find the name associated to the list of values on an active
cell in a spreadsheet?

[Dave Peterson]

Maybe...

You could use Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

That utility has the ability to find the names that refer to the selected
cells. (It may get you close enough for what you want to do.)

Hippy wrote:
>
> Is there a way to find the name associated to the list of values on an active
> cell in a spreadsheet?

--

Dave Peterson

[Hippy]

I was able to find the name range associated to the cell using:

if target.validation.type = 3 then
str = target.validation.formula1
end if

Thanks for your input.

Hippy

"Dave Peterson" wrote:

> Maybe...
>
> You could use Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
> Name Manager:
>
> You can find it at:
> NameManager.Zip from http://www.oaltd.co.uk/mvp
>
> That utility has the ability to find the names that refer to the selected
> cells. (It may get you close enough for what you want to do.)
>
> Hippy wrote:
> >
> > Is there a way to find the name associated to the list of values on an active
> > cell in a spreadsheet?
>
> --
>
> Dave Peterson
>