+ Reply to Thread
Results 1 to 3 of 3

Clear cell contents on closing/opening without clearing formulas

  1. #1
    Registered User
    Join Date
    10-18-2013
    Location
    Ca, USA
    MS-Off Ver
    Excel 2010
    Posts
    25

    Clear cell contents on closing/opening without clearing formulas

    I have formulas in 2 cells (C14 and C16) that return results from data input into other cells. When I close the workbook I would like the contents in C14 and C16 to be cleared and wait until new data is input into the other cells before they return a result. This needs to happen without the formulas in C14/C16 being cleared.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,678

    Re: Clear cell contents on closing/opening without clearing formulas

    What are the other cells involved? I believe that you need to clear the source cells of data and not the formula cells.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-18-2013
    Location
    Ca, USA
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Clear cell contents on closing/opening without clearing formulas

    Attached file. I'm already clearing input cells but calculation cells need to be cleared after use(upon closing or opening)
    Attached Files Attached Files

+ 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 code to clear the contents (or value) of a cell without clearing the formula
    By BazzaBit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2013, 08:16 PM
  2. [SOLVED] How to clear the value of one cell upon opening or closing the workbook.
    By JET2011 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-31-2013, 09:00 AM
  3. clearing cells upon opening or closing
    By sc10 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2010, 10:23 AM
  4. How to clear formula without clearing cell contents
    By prayami in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2008, 04:33 AM
  5. [SOLVED] [SOLVED] Excel should let me clear cell contents without clearing formulas
    By BJM in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2005, 01:00 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