Hi all...

Is there a way to trace where a range of cells that represent a picklist is
used? The range has not been named. Thanks../Randy

try the option Go To and then click on Special.


"Randy Numbers" <(E-Mail Removed)> wrote in message
news:YPmXc.72015$(E-Mail Removed)...
> Hi all...
>
> Is there a way to trace where a range of cells that represent a picklist
> is
> used? The range has not been named. Thanks../Randy
>

Hi Randy,

Presume you have a pick-list but do not know where is the SOURCE use
for the pick-list - right?

If so, pls click in the cell where there is a pick-list > Then click o
Data > Validation > Settings tab. Look at the "Source" option.

Cheers/cskg

--
Message posted from http://www.ExcelForum.com