Hello guys,
i am working on a project and i ran into a problem, i have no idea how to copy paste values when not using the paste function, how can i?
Current code:
With Sheets("main")
.Range(.Cells(4, 1), .Cells(lastrowMain, lastColumn)).Copy Sheets("Backup").Range("A" + CStr(lastrowBackup + 1))
End With
i am working on a project and i ran into a problem, i have no idea how to copy paste values when not using the paste function, how can i?
Current code:
With Sheets("main")
.Range(.Cells(4, 1), .Cells(lastrowMain, lastColumn)).Copy Sheets("Backup").Range("A" + CStr(lastrowBackup + 1))
End With