My Mistake!!!
Forgot the offset part![]()
Sub Copy_JColumn() Dim r As Range Set r = Sheets("DaY").Range("IV1").End(xlToLeft) Sheets("Lists").Range("J1:J103").Copy r.Offset(0, 1) End Sub
![]()
My Mistake!!!
Forgot the offset part![]()
Sub Copy_JColumn() Dim r As Range Set r = Sheets("DaY").Range("IV1").End(xlToLeft) Sheets("Lists").Range("J1:J103").Copy r.Offset(0, 1) End Sub
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks