ActiveSheet.Cells.Copy
Workbooks.Add
ActiveSheet.Paste

That worked great with the macro (which is all I ever asked about ). How 'bout the link info though?

Is there a line of code that will remove any imbedded links on the paste also?

Thanks for your assistance.