I would say depends upon whether or not all the formulas have absolute
references.

If absolute, copypaste specialtranspose.

If relative references, transpose will return #REF! errors.


Gord Dibben MS Excel MVP

On Wed, 28 Jan 2009 14:53:47 -0800 (PST), Skip
wrote:

Can I copy a row of 12 cells/formulas, to a column of 12 cells. I
need the formulas in
the same order. Or do I need to copy each cell separately? thanks
for any assistance
Skip