+ Reply to Thread
Results 1 to 3 of 3

Clear cells with values greater than X

  1. #1
    Registered User
    Join Date
    12-31-2012
    Location
    Poland
    MS-Off Ver
    2016
    Posts
    58

    Clear cells with values greater than X

    What VBA code would check column M and clear contents in cells with values greater or equal to 30,000 as that is what I need to set up?

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Clear cells with values greater than X

    May be something like that
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    863

    Re: Clear cells with values greater than X

    If you only want to clear cells in Column M (and not entire rows) for that criteria, it might be easier without VBA. Filtering out values less than 30K and delete what remains.
    Of course this autofilter can be done using VBA also, this way avoiding loops.
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

+ 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. Clear contents of cells based on the values of other cells
    By macquhele in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2011, 08:49 AM
  2. SOLVED: Clear Cells with Certain Values
    By tjohn909 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-28-2011, 01:11 PM
  3. Replies: 3
    Last Post: 09-29-2010, 01:30 AM
  4. Sum cells in range with values greater than 2
    By henneman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-20-2010, 02:35 PM
  5. return only cells with values greater than 0
    By Sprain Brain in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-02-2010, 05:28 AM
  6. Replies: 3
    Last Post: 12-15-2009, 04:06 PM
  7. Check for values greater than zero in 2 cells
    By spartacus_33 in forum Excel General
    Replies: 4
    Last Post: 11-03-2008, 07:39 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