+ Reply to Thread
Results 1 to 3 of 3

Help with copying another sheet. Only want values and formats

  1. 05-15-2013, 04:00 PM #1
    aaronp
    aaronp is offline
    Registered User
    Join Date
    11-01-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Help with copying another sheet. Only want values and formats

    Can someon help me modify this code so that it doesn't copy the formulas? I only want to copy the values and formats.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 05-15-2013, 06:03 PM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Help with copying another sheet. Only want values and formats

    This copies the sheet with formulas, but then converts the formulas to values.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 05-15-2013, 08:44 PM #3
    aaronp
    aaronp is offline
    Registered User
    Join Date
    11-01-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Help with copying another sheet. Only want values and formats

    Works like a charm! Thank you!
    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)

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