+ Reply to Thread
Results 1 to 4 of 4

Addition to code to copy and pastes special values and cell format, but not links.

  1. 05-08-2014, 04:32 AM #1
    singerbatfink is offline
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    Addition to code to copy and pastes special values and cell format, but not links.

    Hi I have a small piece of code which helps me copy sheet 1 from 24 separate workbooks and then merges them into a singlwe workbook.
    what do I need to do the the code to allow it to only copy the cell formats and values without copying over the whole link to the original documents?
    Thanks

    Please Login or Register  to view this content.
    Last edited by singerbatfink; 05-13-2014 at 03:07 PM.
    Reply With QuoteRegister To Reply
  2. 05-09-2014, 02:23 AM #2
    Miroslav R. is offline
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Addition to code to copy and pastes special values and cell format, but not links.

    Hi there,
    after copy, try to paste in wbk you want with pastespecial method:

    for example:

    Please Login or Register  to view this content.
    This will break you links

    Hope it helps

    Regards

    M
    Reply With QuoteRegister To Reply
  3. 05-13-2014, 03:05 PM #3
    singerbatfink is offline
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    Re: Addition to code to copy and pastes special values and cell format, but not links.

    Quote Originally Posted by Miroslav R. View Post
    Hi there,
    after copy, try to paste in wbk you want with pastespecial method:

    for example:

    Please Login or Register  to view this content.
    This will break you links

    Hope it helps

    Regards

    M
    Perfect Thank you..
    Reply With QuoteRegister To Reply
  4. 05-13-2014, 03:10 PM #4
    Miroslav R. is offline
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Addition to code to copy and pastes special values and cell format, but not links.

    You are welcome...

    Regards

    M
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. A macro that copy and pastes to line below but pastes in a Values and numbers format
    By streyb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2012, 07:06 PM
  2. A macro that copy and pastes to line below but pastes in a Values and numbers format
    By streyb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2012, 03:20 PM
  3. [SOLVED] Set code copy and paste special values
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-25-2012, 08:52 PM
  4. [SOLVED] Code for Copy and Paste Special- Values in Columns
    By gautamacharya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2012, 04:51 PM
  5. [SOLVED] Copy and Paste Special (Formulas) pastes cell value if numeric
    By korrin.anderson@gmail.com in forum Excel General
    Replies: 1
    Last Post: 05-02-2006, 01:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1