loveguy1977
09-17-2013, 02:07 PM
Dear All,
I need to link drop down list from range that saved in xlsm (Add-In). I could able to link it to lookup formula but in Data Validation I couldn't do it.
Lookup example:
B1 is =VLOOKUP(A1,My_ADDINS.xlam!MyRange,2,FALSE)
Where My_ADDINS.xlam is the Add-In, MyRange is the range.
I tried to use the same method in the source of the Data Validation as follow but it didn't work with me.
=My_ADDINS.xlam!MyList
where my MyList is the range name saved in the My_ADDINS.xlam file.
Any one can help please.
Thank you
I need to link drop down list from range that saved in xlsm (Add-In). I could able to link it to lookup formula but in Data Validation I couldn't do it.
Lookup example:
B1 is =VLOOKUP(A1,My_ADDINS.xlam!MyRange,2,FALSE)
Where My_ADDINS.xlam is the Add-In, MyRange is the range.
I tried to use the same method in the source of the Data Validation as follow but it didn't work with me.
=My_ADDINS.xlam!MyList
where my MyList is the range name saved in the My_ADDINS.xlam file.
Any one can help please.
Thank you