+ Reply to Thread
Results 1 to 4 of 4

Delete Cells that contain formulas

  1. #1
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Alberta, Canada
    MS-Off Ver
    365
    Posts
    216

    Delete Cells that contain formulas

    I'm looking to delete all cells on a worksheet that contain a formula... I don't want to keep the value, just clear the formula out.

    Everything I've seen has been to keep the value... I don't want that.

  2. #2
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    528

    Re: Delete Cells that contain formulas

    Is that enough? If not, an attachment is needed.
    HTML Code: 
    Best Regards,
    Maras.

  3. #3
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Alberta, Canada
    MS-Off Ver
    365
    Posts
    216

    Re: Delete Cells that contain formulas

    worked perfect... thanks.

    I was trying to over complicate things again.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Delete Cells that contain formulas

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. Can TRIM not delete formulas in cells?
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-23-2014, 11:16 AM
  2. VBA delete certain cells IF and put back formulas
    By epione in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-08-2010, 03:27 AM
  3. VBA code to find cells with formulas and delete them
    By Richard Flame in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2007, 10:50 AM
  4. Macro to delete row if row blank but cells do have formulas in the
    By Cathy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2006, 08:10 PM
  5. [SOLVED] Code to delete rows and column cells that have formulas in.
    By GarToms in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-18-2006, 02:40 PM
  6. delete cells with formulas
    By Rere in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-28-2005, 02:20 PM
  7. [SOLVED] Question about Cells, Insert, Delete, & Formulas
    By Kevin in forum Excel General
    Replies: 4
    Last Post: 02-20-2005, 12: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1