Results 1 to 2 of 2

Paste special Transpose Not working

Threaded View

learningkid0808 Paste special Transpose Not... 07-18-2013, 02:11 AM
Debraj Roy Re: Paste special Transpose... 07-18-2013, 02:48 AM
  1. #1
    Registered User
    Join Date
    05-10-2011
    Location
    india
    MS-Off Ver
    MS365
    Posts
    28

    Paste special Transpose Not working

    Dear Experts,

    I have trying to build some VBA code. The code is working upto copy, but its not pasting the values in transpose.

    Somone please help me to correct this code .

    Sub OEM()
    Dim Crit1 As String, myfolder As String
    Dim LastRow As Long, LastRow2 As Long, i As Long
    Dim myRange
    
    Application.DisplayAlerts = False
    Application.ScreenUpdating = False
    
    myfolder = Workbooks("update values.xlsm").Sheets("List").Range("I2")
    Application.Workbooks.Open (myfolder & "\" & "OEM Sales Reporting 2013.xlsx")
    
    With Workbooks("update values.xlsm")
    LastRow = Workbooks("update values.xlsm").Sheets("List").Range("A" & Rows.Count).End(xlUp).Row
    For i = 2 To LastRow
    Crit1 = Workbooks("update values.xlsm").Sheets("List").Cells(i, 1).Value
    Cells(i, 1).Offset(0, 2).Select
    Range(Selection, Selection.End(xlToRight)).Copy
    
    'Set myRange = Workbooks("OEM Sales Reporting 2013.xlsx").Sheets(Crit1).Range("A22:N22" & Workbooks("OEM Sales Reporting 2013.xlsx").Sheets("Crit1").Range("A22:N22" & Rows.Count).End(xlLeft).Row).SpecialCells(xlCellTypeVisible)
    
    'myRange.Copy Destination:=Workbooks("OEM Sales Reporting 2013.xlsx").Sheets(Crit1).Range("A22:N22")
    
    
    Workbooks("OEM Sales Reporting 2013.xlsx").Sheets(Crit1).Range("a22").End(xlToRight).Select
    Selection.Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=True
    Next i
    
    Workbooks("OEM Sales Reporting 2013.xlsx").Close SaveChanges:=True
    
    Application.DisplayAlerts = True
    Application.ScreenUpdating = True
    
    End With
    End Sub
    Last edited by learningkid0808; 07-18-2013 at 04:09 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Problem Paste Special Transpose
    By wilest in forum Excel General
    Replies: 0
    Last Post: 04-28-2011, 10:40 AM
  2. Replies: 2
    Last Post: 02-19-2007, 04:53 PM
  3. Cut - Special paste - Transpose ?
    By Jacquesvs in forum Excel General
    Replies: 1
    Last Post: 01-26-2007, 03:13 AM
  4. Paste Special / transpose
    By Ron Carr in forum Excel General
    Replies: 2
    Last Post: 02-24-2006, 02:15 PM
  5. Paste Special Transpose
    By Brian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2005, 11:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1