|Subject:||copying sheet without functions|
|Posted by:||office user (offi…@user.org)|
|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!