+ Reply to Thread
Results 1 to 5 of 5

if cell contain value, then clear range

  1. 06-14-2023, 04:43 PM #1
    chubbychub
    chubbychub is offline
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    849

    if cell contain value, then clear range

    I post the relevant part of the code that i am adding to a current macro:

    Please Login or Register  to view this content.
    if columnA has value, but columnB does not have value (empty) or IsBlank, then clear columnA
    starting from A8 to A49.
    Last edited by chubbychub; 06-14-2023 at 04:53 PM.
    Reply With QuoteRegister To Reply
  2. 06-14-2023, 05:29 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,628

    Re: if cell contain value, then clear range 

    Please Login or Register  to view this content.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 06-15-2023, 05:48 AM #3
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,308

    Re: if cell contain value, then clear range

    Non looping option...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  4. 06-15-2023, 01:33 PM #4
    chubbychub
    chubbychub is offline
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    849

    Re: if cell contain value, then clear range

    thank you sintek and protonLeah, both worked !
    Reply With QuoteRegister To Reply
  5. 06-15-2023, 01:47 PM #5
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,308

    Re: if cell contain value, then clear range

    Glad to have contributed...Tx for rep +
    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] Why does vba clear contents of a cell or range, delete conditional formatting in same cell
    By myou in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2023, 11:37 AM
  2. [SOLVED] Clear cell/remove value in the range matchin cell value in another range
    By G.Bregvadze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2018, 08:39 AM
  3. Clear Cell range upon Changing data in difference Range
    By snuffnchess in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2016, 02:22 AM
  4. [SOLVED] If each cell in range equals 0 then clear contents of range and move to the next row
    By dagardner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-19-2014, 08:44 PM
  5. Clear range based on cell value - clearing cells out of specified range
    By CADiphile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2013, 02:48 PM
  6. a macro to clear a range of data based on cell result - i.e. if A1 = A2, clear C1: C10
    By Capolan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2013, 04:05 AM
  7. [SOLVED] VBA Clear Cells for one range if cell in other range is blank
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2013, 06:23 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