Here i am again with another problem, I am trying to copy a range of cells from 1 worksheet into another, and i am trying to do this in dynamic mode.
here is my coding that obviously doesn't work, I surrounded the code that does not work with >>> <<<<
Legend, Cnt1 points to the current rows and w2_tCol points to the ending column represented in number like column g = 7
For cnt1 = 2 To w1_tRow
Sheets("Temp2").Select
>>>> Range(Cells(cnt1, 1) & ":" & Cells(cnt1, W2_tCol)).Select <<<<< Application.CutCopyMode = False
Selection.Copy
Sheets("Temp1").Select
Cells(cnt1, W1_Tcol + 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Next cnt1
Bookmarks