Bjorn,

You're going to need to give a better explanation, with examples, because that is something I have
never seen when using the TRANSPOSE function. Did you enter the TRANSPOSE function into an array of
cells, and did you enter it with Ctrl-Shift-Enter?

HTH,
Bernie
MS Excel MVP


"kortrijkzaantje" <kortrijkzaantje.1t8waq_1123168000.8193@excelfor um-nospam.com wrote in message
news:kortrijkzaantje.1t8waq_1123168000.8193@excelf orum-nospam.com...

If you have used formulas it is not possible to use transpose function.
You receive a #REF error. Does anyone have an idea or trick to make
this possible?

Greetz,
Bjorn


--
kortrijkzaantje
------------------------------------------------------------------------
kortrijkzaantje's Profile: http://www.excelforum.com/member.php...o&userid=15862
View this thread: http://www.excelforum.com/showthread...hreadid=392915