copying sheet without functions

Giganews Newsgroups
Subject: copying sheet without functions
Posted by:  office user (offi…
Date: Mon, 03 May 2004

Hello to the newsgroup!

I have an excel file with more than 20 sheets containg many functions
relating these sheets. What i want to do is to save SOME of these sheets
to a new file. I want to copy/export only the values of the cells (and not
the functions) but i'd like to keep the colors and general the layout of
each sheet. i know that can copy the source sheet and then do a "special
paste" and insert only the values but this won't keep the colors.

Any ideas? Thanks in advance!