Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste Function
I have a worksheet called Report which recieves its data from 3 spreadsheets,
as part of an email process I am saving the worksheet as a workbook and then emailing to some users. THe problem is that when I save the active worksheet it is keeping all the links associated with the sheet. What I want it to do is copy the values and the formatting but not the links, is there any way to do this Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste Function
One way would be to copy the range and use paste special to overwrite
with the links with the values....... Caution this permanently removes the links so save it as another name. eg If used range is A1 to H16 then....... Range("A1:H16").Copy Range("A1").PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False -- Cheers Nigel "Nigel" wrote in message ... I have a worksheet called Report which recieves its data from 3 spreadsheets, as part of an email process I am saving the worksheet as a workbook and then emailing to some users. THe problem is that when I save the active worksheet it is keeping all the links associated with the sheet. What I want it to do is copy the values and the formatting but not the links, is there any way to do this Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/paste Function | Excel Discussion (Misc queries) | |||
copy and paste function | Excel Worksheet Functions | |||
Copy and Paste function | Excel Worksheet Functions | |||
Copy & Paste value Function | Excel Worksheet Functions | |||
cut,copy paste function | Excel Discussion (Misc queries) |