+ Reply to Thread
Results 1 to 5 of 5

Display Value and Not Formula

  1. 06-21-2018, 09:07 PM #1
    Andrew.Trevayne
    Andrew.Trevayne is offline
    Forum Contributor
    Join Date
    11-02-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    353

    Display Value and Not Formula

    Hi,
    I have this Macro and I wanted the results to display value instead of formulas.
    Any suggestions?

    Please Login or Register  to view this content.
    Appreciate any help. Thanks much.
    Last edited by Andrew.Trevayne; 06-21-2018 at 09:11 PM.
    Reply With QuoteRegister To Reply
  2. 06-21-2018, 09:09 PM #2
    Andrew.Trevayne
    Andrew.Trevayne is offline
    Forum Contributor
    Join Date
    11-02-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    353

    Re: Display Value and Not Formula

    I tried this but also not working.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 06-21-2018, 09:49 PM #3
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Display Value and Not Formula

    Try Evaluate
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  4. 06-21-2018, 10:37 PM #4
    Phuocam
    Phuocam is online now
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,899

    Re: Display Value and Not Formula

    Or try:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 06-21-2018, 11:54 PM #5
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,516

    Re: Display Value and Not Formula

    display value instead of formulas???

    Please Login or Register  to view this content.
    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. [SOLVED] formula to extract max range used inside another formula and display in another cell
    By AndyJr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-04-2018, 11:33 AM
  2. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  3. How to code an IF formula in VBA with text results and display actual formula in cell
    By RyLH87 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 03:40 AM
  4. Cells display formula, not the results of the formula
    By guybrown in forum Excel General
    Replies: 5
    Last Post: 05-29-2009, 07:05 AM
  5. [SOLVED] how to convert a formula into text in order to display the formula
    By Claudio Hartzstein in forum Excel General
    Replies: 2
    Last Post: 07-13-2006, 05:05 AM
  6. How do I display the tab name in a formula
    By Ian in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. Modifying a formula to display the results of another formula
    By carl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1