I have a macro that will pull a couple of sheets out of my workbook to email
to our main office. The problem that I have is when the sheets pull out, the
formulas that are in the sheet are still on the new book that I am sending.
The formulas are referencing the workbook that I pulled it from. When the
new book gets emailed, the workbook is not on the desktop at the office. How
can I get the sheets to pull out and leave nothing but the data and remove
all the formulas.

Thanks
j

j,

Worksheets(1).UsedRange.Value = Worksheets(1).UsedRange.Value

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"justaguyfromky"
wrote in message
...
I have a macro that will pull a couple of sheets out of my workbook to email
to our main office. The problem that I have is when the sheets pull out, the
formulas that are in the sheet are still on the new book that I am sending.
The formulas are referencing the workbook that I pulled it from. When the
new book gets emailed, the workbook is not on the desktop at the office. How
can I get the sheets to pull out and leave nothing but the data and remove
all the formulas.

Thanks
j