Results 1 to 5 of 5

if cell contain value, then clear range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    870

    if cell contain value, then clear range

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

        If Not IsEmpty(i, "A") = "" And IsEmpty(i, "B") Then
            Cells(i, "A").ClearContents
    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.

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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1