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
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