Code: Paste Graph with no Edit-->links

G

Giri

Hi,

Workbook 1, Sheet1 contains a graph (say over cells
A10 to h20 for example) along with source data beside it
(say in cells j10 to m15 as example). The following code
is in a button:
Cells.select
selection.copy
Workbooks.Add
activesheet.paste

The problem is that since it is .paste the graph contains
links to the original workbook/sheet. But in fact i want
the graph & the data to exist here without links to the
original workbook/sheet. What is the code i should change
in the button ?
Note that i tried PasteSpecial with Paste:=xlvalues but
the graphs go for a toss.

Any help in this regard is appreciated. Thank You in
advance.

Regards,
Giri
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open WB, copy each sh. & paste into other WB, regardless of tab na 0
copying all charts as enhanced metafiles 7
Graphing data from multiple worksheets in same workbook 1
copy and paste data (includes groups...) 1
VBA code for pasting links -- modifying RDB code for summary workbook 11
Copy & paste macro for multiple worksheets 8
Having difficulty copying and pasting on VBA 3
Paste Values in linked Cells Only 4

Top