Hi Harry
Don't use Paste Al, use Paste Specialcheck Transpose
--
Regards
Roger Govier



"Harry" wrote in message
...
I am using Office 2003. I have copied some data from a word file in Office
Clipboard. Now I want to paste this all data in MS-Excel. When I
choose the "Paste All" option it pastes all data down side, while I want
to
paste the data right side / left side. How can I change it's pasting
direction? I do not want to use "Transpose" option beacuse it is tadious &
time consuming. I want to do this with a fasttest manner. How can I do
this.
Is it can be done by a macro? If yes then please tell me the macro code.

It is Most Urgent so Please help me as soon as possible.

Hari!