I have a spread sheet, that contains numerous formulas and conditional formating... the workbook has several sheets.. I need to forward the sheet I am refering to.. without the formulas (paste special values) and maintain the result of the conditional formating, however paste special formats does not do it... can anyone help me with this issue..

Thanky you very much

Randy