+ Reply to Thread
Results 1 to 4 of 4

VBA copy and paste values

  1. 02-01-2016, 08:03 PM #1
    lemonap618
    lemonap618 is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    112

    VBA copy and paste values

    This will probably be easy for all...
    I'm looking for the VBA code to copy and paste the values of Sheet1 on Sheet1, thus removing the formulas in the cell.
    I would like to add this to the macro that is already in place "Check_all_conditions_at_once", as the finished product will have a macro button to control all the macros on the workbook.

    Thank you all for the help!
    Regards,
    lemonap
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-01-2016, 08:17 PM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,813

    Re: VBA copy and paste values 

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 02-01-2016, 08:50 PM #3
    lemonap618
    lemonap618 is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    112

    Re: VBA copy and paste values

    Excellent, thank you!
    Reply With QuoteRegister To Reply
  4. 02-01-2016, 08:53 PM #4
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,813

    Re: VBA copy and paste values

    You're welcome.
    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. Autofill Copy and Paste , Cant copy/paste the values
    By fluffyvampirekitten in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2015, 06:10 AM
  2. Copy & Paste Values to Same Cell, While Selecting Different Cell for Copy and Paste Values
    By zhout2 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-23-2014, 11:18 AM
  3. Copy Formulas and Paste into the Last Set # of Rows Only & Paste Values
    By Mr. Ice in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2014, 07:48 AM
  4. copy formula and paste for new data added and autofill.....and paste special values
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2014, 07:40 AM
  5. Copy and paste code pasting won't paste just values
    By thehotbreadguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2013, 11:12 PM
  6. 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
  7. VBA Copy-paste values with changing paste location
    By booost in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-16-2012, 10:39 AM

Tags for this Thread

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