+ Reply to Thread
Results 1 to 5 of 5

All cells to copy & paste as values Except those cells in which formulas starts with =SUM

  1. #1
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010 / 2013
    Posts
    293

    All cells to copy & paste as values Except those cells in which formulas starts with =SUM

    I require all cells to be copy and pasted as values, i.e. to convert formulas in those cells to text or number. (Except those cells in which formulas starting with SUM function/s).

    There are many formulas in the worksheets. I want everything except the cells which contains formulas which starting from "=SUM" on every worksheet to be paste as values. Thanks

    Please refer the file attached.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: All cells to copy & paste as values Except those cells in which formulas starts with =

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: All cells to copy & paste as values Except those cells in which formulas starts with =

    maybe
    Please Login or Register  to view this content.
    less processing for the computer

    ps.: very quickly code in this data sample = max 0.9375 s
    Last edited by mjr veverka; 03-29-2018 at 10:59 AM.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: All cells to copy & paste as values Except those cells in which formulas starts with =

    Quote Originally Posted by porucha vevrku View Post
    maybe
    Please Login or Register  to view this content.
    less processing for the computer
    They're the same. Excel inherently uses the UsedRange in this instance as you can't have formulas outside the used range.

  5. #5
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010 / 2013
    Posts
    293

    Re: All cells to copy & paste as values Except those cells in which formulas starts with =

    It Worked.

    Thank you so much AlphaFrog & Porucha Vevrku

+ 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. Replies: 6
    Last Post: 10-12-2016, 09:34 AM
  2. Copy and Paste Values for cells containing specific formulas
    By SAFC in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2015, 08:23 AM
  3. Copy only cells that contain values from a range cells that contain formulas to next row
    By gjwilson1216 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2015, 11:12 AM
  4. Copy and paste values into next sheet. (blank cells contain formulas)
    By Vlad717 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2013, 06:54 AM
  5. Replies: 5
    Last Post: 11-03-2012, 05:10 PM
  6. macro to copy cells with formulas and paste them as values
    By sammi8796 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2012, 08:00 PM
  7. Formula to copy and paste data in cells to other cells based on values
    By haleakala17 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-11-2012, 08:45 AM

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