Ron De Bruin helped me with the following code
Code
-------------------
Sub test()
Dim wb As Workbook
ActiveSheet.Copy
Set wb = ActiveWorkbook
With wb.Sheets(1)
.UsedRange.Copy
.UsedRange.PasteSpecial xlPasteValues
.Cells(1).Select
Application.CutCopyMode = False
End With
wb.SaveAs "C:\" & wb.Sheets(1).Name & ".xls"
wb.Close False
End Su
-------------------
It copies a worksheet to a seperate file.
But what if I only want to copy C5:K34 to the new file (content no
functions, as above
--
Ruath
-----------------------------------------------------------------------
Ruatha's Profile:
http://www.excelforum.com/member.php...fo&userid=3108
View this thread:
http://www.excelforum.com/showthread.php?threadid=55174