Copy a sheet to a new workbook without the links

[dano1]

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&quot.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.

 

[Mutt]

Can try this :

Sheets("Sheet1&quot.Copy
ActiveSheet.UsedRange.Value = ActiveSheet.UsedRange.Value


Mutt.

 

[sullivandavid]

No code required

Highlight Sheet1

Edit

Copy

Go to Sheet 2

Edit

paste special

Select value
Edit

paste special

Select format