How do I get to know if the list is hard coded in data validation function or used source from a range of cells ?
My answer - Is it when I click the cell containing drop down list and go to data validation function and click on list , in the source area it will show blank if hard coded or a range if some source used ?
Can any one confirm me ?
2 answers ( 0 marked as helpful)
Your answer sounds good!