Hi guys
I have the below code but it doesn't actually do what I need it to do. Basically i want to copy and paste the column from WB2 into the next empty column in WB3. Any help would be greatly appreciated.
Sub Archive()
Dim i As Long
Dim WB2 As Worksheet: Set WB2 = Sheets("New")
Dim WB3 As Worksheet: Set WB3 = Sheets("Archive")
For i = 2 To 13
With WB2
If Application.WorksheetFunction.IsText(.Cells(39, i)) Then
.Range(.Cells(2, i), .Cells(39, i)).Copy Destination:=WB3.Cells(2 + 1, i)
End If
End With
Next i
Bookmarks