Take a look at
http://www.xldynamic.com/source/xld.Dropdowns.html
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Jamesmor" wrote in message
...
Pete,
I have a similiar problem, but don't actually have Excel Hacks, can you
give
me an idea how to get started with this?
"Pete" wrote:
I have tried the example in "Excell Hacks" but it is too complicated to
extend over more than 2 columns. I would like to extend to 10 columns.
A
VBA solution would be OK if necessary.