Solved: copying cell value only when calculated from formula

[ericr]

Well, as the title suggests, I'm trying to copy just the calculated value from a cell in one workbook to another workbook. This new workbook does not have the other values used by the formula to calculate the value. Is there a way to do this?

Thanks.

[mdmackillop]

Sub DoCopy()
Workbooks("Book1.xls").Sheets(1).Range("A1").Copy
Workbooks("Book2.xls").Sheets(1).Range("A1").PasteSpecial xlValues
End Sub

[ericr]

Thanks!