+ Reply to Thread
Results 1 to 3 of 3

Macro to paste values

  1. #1
    Registered User
    Join Date
    01-13-2022
    Location
    Las Vegas
    MS-Off Ver
    2016
    Posts
    2

    Macro to paste values

    I would like to create a macro that allows me to paste values of something copied from one range to another.

    The macro should paste from the clipboard any copied range from any source (another sheet or workbook) and should paste those values into (starting at) a user-selected range.

    I thought this would work, but Error msg 1004 indicates that the Paste Special method of Range has failed. What can I do to make this work?

    Sub PasteValue()
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    End Sub

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to paste values

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-13-2022
    Location
    Las Vegas
    MS-Off Ver
    2016
    Posts
    2

    Re: Macro to paste values

    Thanks for your help and quick reply

+ 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] Need macro to copy and paste formats and values but exclude null values
    By kyle4570 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2021, 08:48 PM
  2. [SOLVED] how to insert empty rows based on column B cell values and paste above values with macro?
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2018, 11:47 AM
  3. [SOLVED] Macro that can cut paste rows, when values are blanks or only show two values in a row
    By ugalskov in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-09-2016, 11:40 AM
  4. Replies: 1
    Last Post: 05-14-2014, 12:52 AM
  5. [SOLVED] Macro to paste formulas then paste values
    By deanstein in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2013, 11:30 AM
  6. Macro to special paste dynamic values into text values with periods
    By iyudhi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2011, 04:42 PM
  7. [SOLVED] Macro needed to Paste Values and prevent Macro operation
    By thunderfoot in forum Excel General
    Replies: 0
    Last Post: 06-10-2005, 03:05 PM

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