Sheets Array help
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 |
Sheets Array help
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 |
All times are GMT +1. The time now is 09:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com