Transposing Formula

Hi,

How can I transpose a formula whilst keeping the existing formula!?

I've found how to:
copy->paste special->transpose
but excel updates the formula, to make it relative I assume. However, I want the original formula to be pasted. Any ideas?

Forgive me if this has already been answered somewhere but I can't find it!

Many thanks

Hey thanks VBA Noob,

I found a simpler answer which achieves what I'm after. I used this function in cell A3:
=TRANSPOSE($A$2:$C$2)
then highlighted cells A3 to A5 pressed F2 and hit ctrl+shift+return. Not 100% sure why it works but it did! I found the answer on the MS site of all places!