thedeadzeds
Active Member
- Joined
- Aug 16, 2011
- Messages
- 442
- Office Version
- 365
- Platform
- Windows
Hi Guys, how do I amend the below to change to paste values only?
Many thanks
Many thanks
VBA Code:
Sub New_copy_to_all_dept()
With Sheets("Master Dept")
.Range("A2:G" & .Range("G" & Rows.Count).End(xlUp).Row).Copy Sheets("All Dept").Range("a" & Rows.Count).End(xlUp).Offset(1)
End With
End Sub