I am trying to copy a row, using paste special "transpose" to paste in a
column, but I dont want to copy any blank fields, How can I do this

Lorraine


--
lorraine knight
------------------------------------------------------------------------
lorraine knight's Profile: http://www.excelforum.com/member.php...o&userid=35294
View this thread: http://www.excelforum.com/showthread...hreadid=551034