To find in entire workbook where a particular given list is used to create a dropdown

Hiii..

I have the source of the list & I want to find out at what all places in the entire workbook this list is used to create a drop down in excel.

Go to Special > Data Validation cells will select all the cells of the data validation..I want to search only for a particular list..

Is this possible??

Thank you.

.
Looking in the area you referred to ... you can view the Sheet name and the range in the RANGE FIELD.

Sorry I didn't got you..can you pls elaborate a bit?

Click on link to see image :

Attachment 627616

Notice in the Range Field the range for the Col and Rows ?

If the list were on a different sheet and/or book from the list, that would precede the range cells.