To copy just formulas from a range.

Select a range then F5SpecialFormulasOK

CopyPaste SpecialAllOK

Note: non-contiguous formulas will be paste into a contiguous range.


Gord Dibben MS Excel MVP

"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...