+ Reply to Thread
Results 1 to 4 of 4

content clearing

  1. #1
    Registered User
    Join Date
    04-22-2019
    Location
    South Dakota, United States
    MS-Off Ver
    2010
    Posts
    3

    content clearing

    I want cells D18, E18 & F3 to clear when the contents of B5 changes
    I have used this code to get D18 to clear, but cant get it to include the other cells


    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: content clearing

    Barring any worksheet / workbook protection, you should be able to add the following to the if statement below the line for D18:
    Please Login or Register  to view this content.
    If that doesn't work, let us know if you receive any sort of error.
    If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.

    If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,084

    Re: content clearing

    How about
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    04-22-2019
    Location
    South Dakota, United States
    MS-Off Ver
    2010
    Posts
    3

    Re: content clearing

    this worked thanks

+ 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. Clearing content in cell when value in other cells changes
    By mikebowman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-11-2018, 11:59 AM
  2. Content in a range is not clearing when i use F5 key
    By shiva_raj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-05-2017, 02:03 AM
  3. [SOLVED] Clearing Sheet Content
    By Kwasimitsu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2014, 02:09 PM
  4. Auto Clearing Content
    By sgris in forum Excel General
    Replies: 1
    Last Post: 12-05-2012, 01:31 AM
  5. clearing content from blank cells
    By cotw in forum Excel General
    Replies: 6
    Last Post: 08-11-2012, 01:44 PM
  6. clearing cell content on MAC?
    By themachine in forum Excel General
    Replies: 4
    Last Post: 07-22-2010, 08:39 AM
  7. [SOLVED] clearing cell content in a macro
    By dziw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-25-2007, 12:02 AM

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