I would like to copy a range of cells, to a new workbook/sheet withou
it linking the formulas back to the original spreadsheet. (Basicall
just capture the result values).

So what I would end up with is a *Static* copy of the sheet.

Here is where I am:

This basically does everything I want, except the new sheet links bac
to the old file for all the formulas.
==========================

Dim strDate As String
ActiveSheet.Copy
strDate = Format(Date, "dd-mm-yy") & " " & Format(Time, "h-mm-ss")
ActiveWorkbook.SaveAs "Part of " & ThisWorkbook.Name _
& " " & strDate & ".xls"
ActiveWorkbook.Close Fals

--
Message posted from http://www.ExcelForum.com