Copied sheet not to have links

  • Thread starter Thread starter CAPTGNVR
  • Start date Start date
C

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
 
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
 
Thank you Alan - it was of great assistance and especially easy to understand
code.
brgds/captgnvr
 
Back
Top