+ Reply to Thread
Results 1 to 5 of 5

Copy Column w/t Formulas to Another Workbook Paste Sepcial

  1. #1
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Copy Column w/t Formulas to Another Workbook Paste Sepcial

    Greeting.
    I am using the following code to copy columns from wb2 (source workbook) to wb1 (destination workbook). Column CA has formulas within the cells that I need to paste as values.
    Please Login or Register  to view this content.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: Copy Column w/t Formulas to Another Workbook Paste Sepcial

    change this:

    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Re: Copy Column w/t Formulas to Another Workbook Paste Sepcial

    alansidman,
    Thank you for your help! Unfortunately, the code stops at the end of the first row in your code.

  4. #4
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Re: Copy Column w/t Formulas to Another Workbook Paste Sepcial

    alansidman,
    Duh, I just realized I didn't copy/paste your entire code. Sorry. Works perfectly!!

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: Copy Column w/t Formulas to Another Workbook Paste Sepcial

    Glad you got it working. Thanks for the Rep

+ 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. How do I copy and paste formulas to new workbook
    By taylorsm in forum Excel General
    Replies: 4
    Last Post: 07-16-2016, 11:35 PM
  2. Replies: 1
    Last Post: 05-02-2014, 12:19 PM
  3. [SOLVED] Macro to copy and paste sepcial into next blank row
    By CharlieZangel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2013, 04:24 PM
  4. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  5. VBA to copy formulas in column D and paste as values in same column
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2012, 05:18 AM
  6. copy/paste column remove formulas
    By sugargenius in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2006, 06:55 PM
  7. [SOLVED] How to copy formulas to a new workbook? Paste Special is different
    By MS-Requestor in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-10-2006, 05:25 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