I ran into the same problem where I had less that the max 250 some-odd
columns/rows required for pasting transposed data but still got an
error message. I solved the problem by scrolling all the way to the
right on the destination sheet and putting the letter X in row 1,
column IA (or whatever it is). After doing that, I could "paste
special ..." the transposed data.