< - is not equal
the line is look for an empty cell - double quotes "" with noting between
them

VBA address cells using the Range statement like Range("A5"). I used the
counter OldRowCount to indicate the row number.

OldRowCount = 5
Range("A" & OldRowCount)

The two statement above is equivalent to
Range("A5")

" wrote:

Thanks Joel,

I am having a little trouble understanding how the code works but only
because i dont know what the line:
"Do While .Range("A" & OldRowCount) < "" " says in english. Do
the following while the value of the range A(OLDROWCOUNT) is what?

My output is always the same, whatever is last in columns A and B,
gets moved to B3 and C4 respectively.

Gotta understand the code completely before i can modify it and use
it.

Thanks again Joel!