No need to post to more than one group and it can waste time of those
trying to help.
Here's the answer given down the road at worksheet.functions.
You can't show more than 8 rows in a data validation drop down.
As for the number of items in the list, I can't seem to get more than
32767, but that should be enough and it makes loading the list very
slow.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
