+ Reply to Thread
Results 1 to 4 of 4

If Cell contains a Formula

  1. #1
    Forum Contributor
    Join Date
    04-23-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    100

    If Cell contains a Formula

    Hi,

    Is there a VBA method to check each cell in a sheet to see if it contains any type of formula,
    and if so, convert it to a Value?

    Thanks.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: If Cell contains a Formula

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    04-23-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    100

    Re: If Cell contains a Formula

    Thanks John (again).

    This is linked to that earlier post, in that, before I save to a .xlsx format workbook, I need to preserve the user's data as fixed values.

    In the original .xlsm book, these formulae are generated partly by code, and partly by worksheet formulae
    placed into the cells.

    Many are interdependent.

    I'm thinking that I will have to be careful as to the sequence in which formulas are converted to fixed values ?

    Regards.

  4. #4
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: If Cell contains a Formula

    Why not just convert the entire range to values instead of looping through each cell as the end result will be the same?
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

+ 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. VBA to enter formula in cell not calculating...showing formula in cell
    By kmlloyd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2015, 06:42 PM
  2. [SOLVED] Enter formula result from one cell into a COUNTIF formula in another cell. Help please!
    By gregrach in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 11:23 AM
  3. Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  4. [SOLVED] Retaining formula cell references when copying a formula to a different cell
    By FrankParisi in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2013, 07:05 AM
  5. Replies: 5
    Last Post: 05-07-2013, 08:34 AM
  6. Change Cell Font Color if Cell Contains Formula Referencing Another Cell
    By wilcox.patrick in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2012, 10:24 PM
  7. Replies: 2
    Last Post: 03-07-2008, 08:05 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