Copy & Transpose Range Macro Code

    Hi folks,
    I want to copy a row of data and paste it as a column, but without the cursor having to select a cell, if you know what I mean. So basically, I want to copy, using the destination method instead of using pastespecial:


    Code
    Range("A1:A10").Copy Destination:=Range("O50")


    I want this row to be transposed into

    Code
    Range("O50")


    Any idea how to do this without pastespecial?


    sabatier

    Re: Vba Transpose Without Pastespecial


    What's wrong with transpose ??


    Code
    Dim Rng As Range
Set Rng = Range("A1:A10")
Rng.Copy
Range("O50").PasteSpecial Paste:=xlValues, Transpose:=True


    VBA Noob

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login