I have a workbook with 30 worksheets. One Master sheet and 29 report
sheets with initial name starting with 'R1' to 'R29' which contains
links,formulas,functions,modules.

I want to export all the 29 report sheets to a new workbook without the
links,formulas,functions,modules but just containing the values.I am
doing this for reducing file size.

How to do this in vba?Please help.

Thanks.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/