Thread
:
populating a validation list
View Single Post
#
3
Posted to microsoft.public.excel.programming
Daniel.C
external usenet poster
Posts: 43
populating a validation list
Sorry for wrong posting
Daniel
"Risky Dave" a écrit dans le message
de news:
...
Hi,
I have some code that populates a data validation list automatically. The
list has approxiately 20 entries and the
VB
code will not allow me to have
that many - it throws up an error message when trying to run the line.
To get round this, I have simply pointed the code at a range of cells way
off from where the user will be working. The problem with this is that if
rows are deleted, the references become invalid, as the list of valid
entries
effectively "moves up" the page.
Can anyone suggest another way around the limit
VB
is placing on the
number
of items in my list?
TIA
Dave
Reply With Quote
Daniel.C
View Public Profile
Find all posts by Daniel.C