Help with xlPastespecial command in my VBA Code

[rv02]

Dear All

I have a vba code that selects the pre selected Print Area and copies it to a new sheet. The area contains a Pivot table and a pivot chart from another ivot data.

The copy command work but it only copies the Pivot table and not the chart. I use the xlPastespecial Paste:=All command.

When I do the copy and paste manually it works but I think the command copies the values and not the ha\rt. Is there any way I can have a code to copy the selected area as a normal Past i.e. Ctrl C and Cltr V command or just pate it selection as Picture. The code then emails the new sheet to the selected recipients and I only need the selected area to be emailed.

Thanks in advance for your help

[davesexcel]

You haven't supplied the code you are referring to.

[rv02]

Sorry

the code is below which I got from forum's help

Please Login or Register  to view this content.