Forum Discussion
Some basic VBA Excel scripting questions
Hey, I would like to copy the entire contents of one Excel sheet from one project to a different sheet in a different project, using VBA scripting. How would I do this? Then, I would like to ...
Sub CopyValuesFromOneSheetToAnotherSheet()
With Worksheets("Source").Range("A1").CurrentRegion
.Offset(1).Resize(.Rows.Count - 1).Copy _
Worksheets("Destination").Range("A" & Rows.Count).End(xlUp).Offset(1)
End With
End Sub