+ Reply to Thread
Results 1 to 2 of 2

Selection.PasteSpecial Paste:=xlValues

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Milan, Italy
    MS-Off Ver
    Excel 2003
    Posts
    33

    Selection.PasteSpecial Paste:=xlValues

    "Sub PasteValues()
    Selection.PasteSpecial Paste:=xlValues
    End Sub"


    Hello could you give me the meaning of this "Selection.PasteSpecial Paste:=xlValues" ?

    what does this line do?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: Selection.PasteSpecial Paste:=xlValues

    If you have selected a range containing formulas, the "PasteSpecial Paste:=xlValues" will paste, well, the values of the formulas, not the formulas.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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] Intermittent Error 1004 on Selection.PasteSpecial
    By BeachRock in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 10-21-2012, 01:23 AM
  2. Is Pastespecial supposed to change selection?
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2010, 09:42 PM
  3. re-assign paste functionality/shortcut/key to pastespecial xlvalues
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2010, 04:40 PM
  4. [SOLVED] Paste vs PasteSpecial
    By Gary''s Student in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2006, 02:35 PM
  5. [SOLVED] Selection.PasteSpecial with Office 2003
    By Andreas Szabo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2005, 10:20 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