transpose and formulas

[Hein]

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

 

[davesexcel]

Here is a neet trick,
Highlite the range you want to transpose and go to eddit=>find
enter the equals sign =
and then click replace, replace with the quotes sign "
replace all, now the cells are text
copy and transpose to where you want and then go to edit =>Find
Find the quotes " replace all with the equals sign =
your formula has not changed

 

[Hein]

Dave
Thanks for your reply and sorry for my delayed answer: my computer got
a bug and I had to wait until I got at my work :-(

Sometimes the solution is a simple one!
I will follow your suggestion

Thanks again
Hein

 

[davesexcel]

Hope it works