if you have 500 rows and you want to transpose that to columns it will
not work as excel only has 256 columns.


--
clane
------------------------------------------------------------------------
clane's Profile: http://www.excelforum.com/member.php...o&userid=11865
View this thread: http://www.excelforum.com/showthread...hreadid=475086