MarkVMcCullagh
Board Regular
- Joined
- Oct 22, 2002
- Messages
- 72
How do I modify the following line within VBA to paste special values, formats and column widths?
WS.Range("d22:t42").Copy Destination:=Sheets("Consolidated").Range("A65536").End(xlUp).Offset(1, 0)
Thanks in Advance
WS.Range("d22:t42").Copy Destination:=Sheets("Consolidated").Range("A65536").End(xlUp).Offset(1, 0)
Thanks in Advance