Programmatically Extracting Validation List
ACtually Formula1 returns '=' in front of the range address. So instead, use:
address = strings.replace(activecell.Validation.formula1,"=" ,"")
--
Regards,
Sébastien
<http://www.ondemandanalysis.com
"sebastienm" wrote:
Say you want the data validation list associated with the active cell
dim address as string
dim rg as range
address=activecell.Validation.formula1
set rg=application.range(address)
--
Regards,
Sébastien
<http://www.ondemandanalysis.com
"Barb Reinhardt" wrote:
I have a selection that has a validation list attached to it and I'd like to
extract the list that's tied to it programmatically. How would I go about
doing that?
Thanks,
Barb Reinhardt
|