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

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"CAPTGNVR" wrote:

> 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

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

> 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
>
> --
> Alan Moseley IT Consultancy
> http://www.amitc.co.uk
>
> If I have solved your problem, please click Yes below. Thanks.
>
>
> "CAPTGNVR" wrote:
>
> > 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