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