First do an edit / replace and replace = with %%
Then copy and paste special transpose
Then do an edit / replace and replace %% with =
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
"Stephen_Rammer"
<Stephen_Rammer.2blzlg_1154011810.1741@excelforu m-nospam.com wrote in
message news:Stephen_Rammer.2blzlg_1154011810.1741@excelfo rum-nospam.com...
Yes, it just returns a lot of REFS#
--
Stephen_Rammer
------------------------------------------------------------------------
Stephen_Rammer's Profile:
http://www.excelforum.com/member.php...o&userid=36850
View this thread: http://www.excelforum.com/showthread...hreadid=565563