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

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


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

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


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

Hope it works


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