Copy and paste the whole row, constants, formulas, everything. Then select
the row you just pasted. Hit the F5 key. Select Special - Constants. This
selects only those cells that have constants. Hit the Delete key. HTH
Otto
"camlad" wrote in message
...
Having copied a row I need to paste ONLY the formulas which occur in some
cells into another row. I want to leave the other cells empty and not
paste
in the values.

I asked a similar question earlier (12/11/2008 3:41) but did not get a
satisfsactory answer - I only want the formulas pasted into the new row.

Any suggestions?