The intent here is simple. On sheet1, Column A1-A100, each cell is allowed a certain entry as determined by a list in B1-B6. Very simple.
Here is the VBA code that works.
If I add the following variablePlease Login or Register to view this content.
secstr = "$B$6" and substitute the following for rlist:
rlist=Chr(34) & "$B$1:" & secstr & Chr(34), it results in rlist being exactly "$B$1:$B$6" as before, but the procedure fails, the dreaded Run time error 1004 that hangs on the 2 lines starting with .ADD.
Here is the modified code.
Please Login or Register to view this content.
Any ideas?
Bookmarks