You can't filter rows. You can transpose your worksheet using
pastespecial to switch rows and columns. There is no problems doing
this with 2007 but witth 2003 you are limited to 256 columns. so if
your original worksheet has less than 256 row with 2003 you can tranpose
the sheett, otherwise, you can't.
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=182901
Microsoft Office Help