+ Reply to Thread
Results 1 to 2 of 2

Formulas to Constant Value

  1. #1
    Forum Contributor
    Join Date
    05-15-2015
    Location
    Orlando, FL
    MS-Off Ver
    Office Standard 2016
    Posts
    266

    Formulas to Constant Value

    Hi Everyone,

    We have an active working spreadsheet that is pulling percents based on a date range. I'm looking for help with a macro that could turn the range I12:AH358 into a constant value only IF its returning a value. My formula is referencing dates (some of which are in the future), so its showing a blank. When its showing blank, I want the formula to stay. If its returning a value, I want it to get rid of the formula and just show the value.

    In the attached screen shot, you will see values are showing up to column R. Is it possible to do a macro to turn all these to this value (removing the formula), but leave the formula in all columns S and beyond?
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    03-28-2018
    Location
    Houston, TX
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    127

    Re: Formulas to Constant Value

    The font in the picture is so small it's difficult to work with. It would be ideal if you could post a sample workbook.

+ 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. Change formulas to constant value
    By jharvey87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2019, 12:48 PM
  2. Keeping formulas constant for only part of rows
    By Philip63 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-20-2018, 10:24 AM
  3. [SOLVED] Two formulas - combine them and have constant password?
    By jokris in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-28-2016, 12:40 PM
  4. [SOLVED] Formulas to remain constant
    By backyardfun in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-04-2014, 07:26 AM
  5. Dragging Down Formulas with Constant Cells
    By rylock in forum Excel General
    Replies: 2
    Last Post: 06-09-2008, 11:39 PM
  6. Evaluate constant text formulas
    By phyxsius in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2008, 07:33 AM
  7. [SOLVED] How to keep formulas constant
    By [email protected] in forum Excel General
    Replies: 4
    Last Post: 06-29-2006, 03:10 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