I've created a macro to copy a range of data from one worksheet to another and it works fine. However, I'd like to change this so that it copies through to the last row of data rather than specifying a numbered row.
This is what I have so far:
This also works (from a Macro recording), but it's slow and clunky:
Thanks!
This is what I have so far:
VBA Code:
Sub Macro2()
Worksheets("Raw Data Line Items").Range("A4:D4").Copy
Worksheets("Transformed").Range("A26").PasteSpecial
End Sub
This also works (from a Macro recording), but it's slow and clunky:
VBA Code:
Sub Copy()
Sheets("Raw Data Line Items").Select
Range("A4:D4").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("Transformed").Select
Range("A26").Select
ActiveSheet.Paste
End Sub
Thanks!