I cannot replicate this - I seem to be able to specify any target area.
Suggest you try by just clicking the one cell where you want the first entry
to be on the target worksheet, then use Paste Special/transpose
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Brian86" wrote in message
...
I cant seem to transpose a column from the original worksheet to a new
worksheet without recieving a message that states that the area into which
I
would to like to transpose is not the same size and shape. Where am I
going
wrong?