+ Reply to Thread
Results 1 to 2 of 2

Change vba to only paste values

  1. #1
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    375

    Change vba to only paste values

    Hi I have the following code however it's pasting the formula as well i.e. =h16 etc. I want it to copy the formatting of the cell so it's looks the same but only with the value not a link.

    Please Login or Register  to view this content.

    I can't see the pasting part to change it.

    Cheers

    Dave

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,401

    Re: Change vba to only paste values

    Hi,

    If you want to only paste values, you have to use this (pastespecial):

    Please Login or Register  to view this content.
    GC Excel - My blog

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

+ 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. vba on change, filter range and paste filtered values into table
    By wacky_diva in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-06-2016, 01:08 AM
  2. [SOLVED] Selection change - Copy & Paste values
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2014, 11:29 AM
  3. [SOLVED] Change code to paste as special (values)
    By zipaway in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2014, 10:37 AM
  4. change values to lower case & paste in a different column
    By RobinPrice in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2014, 06:30 PM
  5. Change macro to paste values instead of forumla
    By simonbpp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-17-2013, 06:30 AM
  6. [SOLVED] Trying to Change this code to make it paste 'Values' only.
    By RWarczy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-23-2013, 05:11 PM
  7. [SOLVED] Change existing MACRO to only copy/paste Values
    By williampdx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2012, 08:07 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