i new vba working loops. trying create "do until (or while)" loop pulls drop down list in excel, , once pulls correct data drop down, continue proceed on other columns right of drop down. in current statement below, need add 'if' statement or other type of procedure process? can me understanding of how works , coding on right track?
sub main_territories() range("c23").select until activecell.value = "" if territories = 1 territories_1 = activecell.value elseif territories = 2 exit territories_2 = activecell.value else territories_3 = activecell.value end if territories = territories + 1 activecell.offset(1, 0).select loop end sub
Comments
Post a Comment