UPDATING VALIDATION LIST

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

http://www.ozgrid.com/News/excel-validation-tips.htm

Please consider the following, under "Excel VBA Tips and Tricks", then
"Updating Validation List", and note there is a link..."Download a working
example from here".

I think I understand what's going on here (as the author intended it to be
used). But if we deviate from his/her plan and delete all but the first two
names that have been entered, then his/her code doesn't work.

Can someone explain what the problem is with the code? And, since the code
doesn't work if you delete all the names, how does one get started with a
new list of "Names"?

Thanks,
Bernie
 

Ask a Question

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.

Ask a Question

Back
Top