It needs work-arounds. What is the formula that you are using and some
sample data?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"philcud" <philcuddy@gmail.com> wrote in message
news:1125569808.582148.100790@g47g2000cwa.googlegroups.com...
> hi all,
> have created a drop down box that is dependent on another cell, using
> the indirect function to get the name from another cell.
> heowever, when i amend the names to dynamic ranges, this stops the drop
> down boxes getting their list - anyone got dependent drop down boxes to
> workj with dynamic ranges?
>