if myrow were equal to 6, it would refer to cell IV6 which is the rightmost
cell in the worksheet. (column IV)

It then comes left until it finds the first cell not empty and goes to the
cell to the right of that (next empty cell in the row).

It then assigns a value to it.

--
Regards,
Tom Ogilvy

"Michael168 " wrote in message
...
Hi!

I need someone to explain to me the below vb code. What does it means
in plain english.

Range("IV" & myRow).End(xlToLeft)(1, 2).Value = _
myRange.Cells(i, j).Value

I don't understand the "IV". What does it means? I cannot find it in
the module.

Thank you.
Michael


---
Message posted from http://www.ExcelForum.com/