Hi Tom Ogilvy,

Thanks for explaining. How do I change the starting columns to "Col K
instead of the next empty cell to the right? I means fix it to start a
column "K".

=======
Old code #

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

Regards,
Michael

Tom Ogilvy wrote:
[b]if myrow were equal to 6, it would refer to cell IV6 which is th
rightmost
cell in the worksheet. (column IV)

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

It then assigns a value to it.

--
Regards,
Tom Ogilv

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