+ Reply to Thread
Results 1 to 3 of 3

Clear contents for a few non-adjacent ranges

  1. #1
    Forum Contributor
    Join Date
    01-15-2013
    Location
    London
    MS-Off Ver
    Excel 2003, 2007, 2010, 2019
    Posts
    436

    Clear contents for a few non-adjacent ranges

    Hi everyone,

    I got a code below to clear contents for a few non-adjacent ranges. But it does not look very neat. Is there a clever way to make it look better? Thank you.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Clear contents for a few non-adjacent ranges

    One way:-
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-15-2013
    Location
    London
    MS-Off Ver
    Excel 2003, 2007, 2010, 2019
    Posts
    436

    Re: Clear contents for a few non-adjacent ranges

    Thank you, MickG. It looks much tidy

+ 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. I need to code to clear contents the several fixed ranges of several sheets
    By samahhamaad in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-03-2016, 05:21 PM
  2. [SOLVED] Change dropdown option will clear contents of 2 adjacent cells
    By deraj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2016, 03:52 AM
  3. Clear merged cell contents in comand button(clear all)
    By mohan_984 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-25-2015, 10:39 AM
  4. [SOLVED] vba to clear contents in specific ranges on active sheet
    By blackburnsexcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-01-2014, 09:35 AM
  5. [SOLVED] VBA Code - Compare Adjacent Cells In two columns and clear contents when a match is found
    By Langer101 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-03-2013, 06:22 AM
  6. Macro that will clear contents of cell based on format of text in adjacent cell
    By judasdac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2012, 01:56 AM
  7. macro to clear contents of two ranges if cell is blank
    By fisher-price in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2011, 10: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