Hi - I was not clear in my question (on me, not on you nice folks who
answered). I have a worksheet that I would like to reuse, without the data. I
can't find a way to copy the formulas, where they are, and have the new sheet
just have them, with zeroes. Since they are all over the place, I thought
there would be an easier way to just keep them and lose the data rather than
copy the sheet and then remove the data manual. Maybe not...

/s

"Chip Pearson" wrote:

Paste Special Formulas strips formatting and pastes the unformatted results.
Try it with dates and times and you'll get the serial values.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Suzi-Q" wrote in message
...
If Edit, Paste Special values strips the formulas from a range and leaves
the
values, I would expect Edit, Paste Special, Formulas to do the opposite.
But,
it doesn't. So, I have two questions: 1) Is there anyway to copy a range
and
paste just the formulas in the result? 2) What exactly is Edit Paste
Special
Formulas supposed to do? (to me, it looks just like copy, paste but maybe
I'm
missing something) Any assistance would be greatly appreciated...