Hi All
I want to copy and paste a range's value, format and formulas, I have a macro below and please could you let me know how to edit it to make all of the values/format/formulas be included? Thanks.
I want to copy and paste a range's value, format and formulas, I have a macro below and please could you let me know how to edit it to make all of the values/format/formulas be included? Thanks.
VBA Code:
Private Sub Copy()
Dim Last_Row As Long
Sheets("Master").Select
Last_Row = Range("A" & Rows.Count).End(xlUp).Row
Dim LR As Long
LR = Sheets("Copy").Range("A" & Rows.Count).End(xlUp).Row
Sheets("Copy").Range("A2:AC" & LR).Copy
Sheets("Master").Range("A" & Last_Row + 1).PasteSpecial
End Sub