+ Reply to Thread
Results 1 to 2 of 2

Problem with paste special

Hybrid View

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    57

    Problem with paste special

    Hi there,

    I have been using this same code many times but for some reason this is not working now when I try to copy-paste values between two workbooks. Highly appreciate if you could help me with this issue.


    Sheets("aaaa").Range("a1:O" & lastrow2).Select
    Selection.Copy
    Dim mastervika As Integer
    
    Workbooks.Open (Taxfree.Tiedosto)
    Sheets("XXXXXXX").Select
    mastervika = cells(Rows.Count, "B").End(xlUp).Row
    ActiveSheet.cells(mastervika + 1, 1).Select
    ActiveSheet.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
                    :=False, Transpose:=False
    Cheers,

    Ville

  2. #2
    Registered User
    Join Date
    04-24-2013
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Problem with paste special

    Problem solved.

    Sheets("aaaa").Range("a1:O" & lastrow2).Select
    Selection.Copy
    Dim mastervika As Integer
    
    Workbooks.Open (Taxfree.Tiedosto)
    Sheets("XXXXXXX").Select
    mastervika = cells(Rows.Count, "B").End(xlUp).Row
    ActiveSheet.cells(mastervika + 1, 1).Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
                    :=False, Transpose:=False

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Paste Special problem
    By Alexraguet in forum Excel General
    Replies: 3
    Last Post: 07-16-2012, 07:58 AM
  2. Problem with paste special
    By tucsonpepe in forum Excel General
    Replies: 2
    Last Post: 11-02-2008, 08:15 PM
  3. Paste special problem
    By Brian Matlack in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2006, 02:48 PM
  4. Paste Special Problem
    By ajkim001 in forum Excel General
    Replies: 1
    Last Post: 03-10-2006, 07:55 PM
  5. Problem with Paste Special
    By Mike W in forum Excel General
    Replies: 2
    Last Post: 05-05-2005, 11:06 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