excel vba - VBA copy from a union of two ranges to a row of another range -
dear competent people. i'm having problem following code, sub completes correctly not copy correct data correct location. repeating pattern of lines of zeros not correlate iterators in place. i think problem copying values sub-set of range, episode&r. looked @ using union property shown wrong commenter below. currently 9 ranges named "episode"1-9 each row of contains data 1 respondent. columns 5 through 15 of these ranges contain data copied, therefore range copied each respondent is: row i, columns 5 through fifteen. step stuck with. if copy it, data end on sheet2 range has been named each respondent, called respondent&n. rows of response&n represent time slots during episode&r can occur. outside of slots episode&r occurs there can zeroes, isn't necessary. the logical structure appears work fine. have watched local values counters closely in debugging , work supposed to. i looking @ using range.item method select row 'n', c