teatimecrumpet
Active Member
- Joined
- Jun 23, 2010
- Messages
- 307
Hi,
I'm having trouble with keeping the formatting when using the "Destination:=".
It "pastes" it fine. But the columns are not autofit as the original was. Would it be better to paste instead of using Destination:= ?
My code:
Sheets.Add.Name = "FD"
Worksheets("TD").PivotTables("TD").TableRange2.Copy _
Destination:=Sheets("FD").Range("A3")
Thanks,
Mike
I'm having trouble with keeping the formatting when using the "Destination:=".
It "pastes" it fine. But the columns are not autofit as the original was. Would it be better to paste instead of using Destination:= ?
My code:
Sheets.Add.Name = "FD"
Worksheets("TD").PivotTables("TD").TableRange2.Copy _
Destination:=Sheets("FD").Range("A3")
Thanks,
Mike