Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copied sheet not to have links
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copied sheet not to have links
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copied sheet not to have links
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph links to copied sheet | Charts and Charting in Excel | |||
how to unlink links copied from a list from the internet | Excel Discussion (Misc queries) | |||
Word O7 looses links with excel 07 when files copied to network fr | Links and Linking in Excel | |||
Chart links for copied sheets | Excel Programming | |||
Programatically Breaking Links of Copied Chart Sheet | Excel Programming |