Ok, sorry....I should have mentioned that I'm trying to copy a list from
another source. What you're telling me to do now makes perfect sense but
it does not want to past w/ the transpose because the number of cells is
not the same size/shape. I don't see a way to count this and there are
currently 573 cells to paste.

Sorry, I'm sure this is pretty basic stuff.


--
FattyLumpkin
------------------------------------------------------------------------
FattyLumpkin's Profile: http://www.excelforum.com/member.php...o&userid=25530
View this thread: http://www.excelforum.com/showthread...hreadid=389649