Copying a range of cells and pasting them by using Transpose function

[Nikhil Reddy]

Hi i'm New to Excel Programming.

Can you plz help me out how to use this transpose function in vbscript..

1 2 3 4 5

The above range must be copy and the result must be in below format

1 2 3 4 5