Hi all
I've searched the board but can't find a satisfying answer, although I
can't imagine that this question hasn't been answered before.


I need to transpose a range of cells that consists mostly of formulas
When I do this the formula changes.
I';ve tried tranposing it with the normal formula, eg. +d4 and as
+$d$4
Both methods failed.
Since there are more than 3000 cells I need to transpose I don't want
to make the new formula again, by hand

How can I tranpose a range and maintain the correct formula
The help function doesn't give me any information either


Who knows what to do

Thanks again
Hein

PS
The last 3 times I've logged in on this forum my McAfee scanner alerts
me that somebody is sending e-mails from my computer to himself, no
doubt with information off my computer.
It only happens when i log in on this site. When I restart it
dissappears but as soon as I log in on this site it starts all over
Apparently it is some Russian @#$!&
What can I do, or what can the Excelforum do to stop this


--
Hein
------------------------------------------------------------------------
Hein's Profile: http://www.excelforum.com/member.php...o&userid=24744
View this thread: http://www.excelforum.com/showthread...hreadid=526340