+ Reply to Thread
Results 1 to 3 of 3

Copy Destination:= only values

Hybrid View

JimDandy Copy Destination:= only values 07-19-2017, 01:55 AM
tax112 Re: Copy Destination:= only... 07-19-2017, 02:09 AM
buran Re: Copy Destination:= only... 07-19-2017, 02:12 AM
  1. #1
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Copy Destination:= only values

    I have the following code that does a great job of pasting what's in the cell but I'd like it to paste values only. In the source cell I have formulas but I'd like to copy just the values. I've tried various strings to add to the end but cannot seem to find the right syntax.
            Worksheets("Module").Range("D14:D26").Copy _
                Destination:=Worksheets("Module").Range("AK14")
    Last edited by JimDandy; 07-19-2017 at 02:46 AM.

  2. #2
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    442

    Re: Copy Destination:= only values

    Try:
    Change
    PHP Code: 
    Worksheets("Module").Range("D14:D26").Copy 
    to
    PHP Code: 
    Worksheets("Module").Range("D14:D26").SpecialCells(xlCellTypeConstants23).Copy 
    Last edited by AliGW; 07-19-2017 at 03:12 AM.

  3. #3
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Copy Destination:= only values

    Removed, because of the Mod request. I was posting together with the Mod.
    If you are pleased with a member's answer then use the Star icon to rate it.

+ 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. Copy from static destination & paste to dynamic destination
    By Marbleking in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-31-2015, 09:31 AM
  2. [SOLVED] Destination copy and paste (values only) for copy loop
    By mr_mango81 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2013, 08:59 PM
  3. copy destination
    By Brontosaurus in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-11-2010, 12:21 PM
  4. Using destination filepaths listed in cell contents opposing to coding destination
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2009, 01:23 PM
  5. Help with copy destination
    By David in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2006, 04:55 AM
  6. [SOLVED] copy paste values only using destination:=
    By Spike in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2006, 07:30 PM
  7. copy destination values
    By Pete in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2005, 01:06 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