Copy a sheet to a new workbook without the links
Copy a sheet to a new workbook without the links
(OP)
How do I copy a sheet to a new workbook in Excel without establishing the links to the original sheet? Right now, my code is Sheets("Sheet1").Copy. But that establishes links back to my source workbook. I just want the values. I know I could use select all of the cells I want to copy and then use the paste special command, but I'm actually copying more than one sheet. Any ideas?
Thanks in advance for the help.
Thanks in advance for the help.





RE: Copy a sheet to a new workbook without the links
Sheets("Sheet1").Copy
ActiveSheet.UsedRange.Value = ActiveSheet.UsedRange.Value
Mutt.
RE: Copy a sheet to a new workbook without the links
No code required
Highlight Sheet1
Edit
Copy
Go to Sheet 2
Edit
paste special
Select value
Edit
paste special
Select format