Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston, Massachusetts, USA
    Posts
    205
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cut Row and Paste as Column (Excel 2000 or XP)

    Does anyone know a way to cut an entire row and paste it as a column in an Excel Worksheet?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Cut Row and Paste as Column (Excel 2000 or XP)

    Does this do what you want?
    Steve
    <pre>Option Explicit
    Sub TransposeRowToColumn()
    Dim rngS As Range
    Dim rngD As Range
    Dim vArray
    Dim i As Integer
    Set rngS = Application.InputBox("What is the Source Range", Type:=8)
    Set rngD = Application.InputBox("What is the Destination", Type:=8)
    Set rngD = rngD.Cells(1, 1)
    vArray = rngS
    rngS.ClearContents

    For i = 1 To UBound(vArray, 2)
    rngD.Offset(i - 1, 0) = vArray(1, i)
    Next
    End Sub</pre>


  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston, Massachusetts, USA
    Posts
    205
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cut Row and Paste as Column (Excel 2000 or XP)

    Yes, this does what I want. Thank you!!!!

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cut Row and Paste as Column (Excel 2000 or XP)

    You can't do that directly. You either have to use VBA like Steve showed you, or do it in a three step process. Select the data to be moved and do Edit/Copy. Select the cell in the column where you want the data to start. "Select PasteSpecial...", tick Transpose at the bottom of the dialog box, and click OK. Now, delete the original data.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •