Hi, thank you for help me!
I have 2 columns and I need to copy down the value in the first-one
until the adjacent column be empty.
I can't define any range because the list will vary every time.
¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬
name1    1
?    2
?    3
?    4
?    5
.    6
.     7
.    8
¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬

I was thinking in something like:
 i = 0
For Each cellA In rA
For Each cellB In rB
  i = i + 1
.Cells(i, 3) = cellA
.Cells(i, 4) = cellB