Copied sheet not to have links

[CAPTGNVR]

Dear All

WorksheetA; sheet1 has links to sheet2;

sheet1 is copied to another new workbook by vb using cells select, selction
copy and activesheetpaste and saved as sheet1_copy.

The problem is that the data changes in sheet1_copy when worksheetA-sheet2
data is changed.

Can u pls tell me how to get over this.

brgds/captgnvr

 

[Alan Moseley]

You need to use the PasteSpecial method. Here is an example:-

Dim ws As Worksheet
Set ws = Sheet1
Selection.Copy
Set ws = Sheet3
ws.PasteSpecial (xlPasteValuesAndNumberFormats)
Set ws = Nothing

 

[CAPTGNVR]

Thank you Alan - it was of great assistance and especially easy to understand
code.
brgds/captgnvr