Thread: Code Question
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Code Question

Hi Michael,

. 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 at
column "K".

=======
Old code #

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


Try:

Range("K" & myRow).Value = myRange.Cells(i, j).Value


---
Regards,
Norman



"