Ranges in different columns, but same row (VBA)

Asked

Viewed 32 times

1

I have 3 different ranges of different values, for example: Range1(a,b,c), Range2(d,e,f), Range3(g,h,f). These 3 ranges are already in specific worksheet columns, that is, the first in column B, the second in C and the third in D. However, I need a code that distributes them in these columns automatically so that they never stay in the same row and in order of priority. For example: Range 1, will be distributed in column B, occupying lines 1, 2 and 3. Range 3, in column C , occupying lines 4 , 5, 6, and so on, alternately. Could help?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.