+ Reply to Thread
Results 1 to 3 of 3

Macro to clear Fill Coloured items only from row 9 in Col E

  1. 07-03-2020, 10:46 PM #1
    Howardc1001
    Howardc1001 is online now
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,725

    Macro to clear Fill Coloured items only from row 9 in Col E

    I have written code to clear coloured items from row 9 in Col E, but when running the macro it does not clear this data


    Please Login or Register  to view this content.

    It would be appreciated if someone could kindly amen my code


    I have attached sample data
    Attached Files Attached Files
    Last edited by Howardc1001; 07-03-2020 at 10:53 PM.
    Reply With QuoteRegister To Reply
  2. 07-03-2020, 11:31 PM #2
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,410

    Re: Macro to clear Fill Coloured items only from row 9 in Col E

    Does this macro do what you want...
    Please Login or Register  to view this content.
    Last edited by Rick Rothstein; 07-03-2020 at 11:53 PM.
    Reply With QuoteRegister To Reply
  3. 07-03-2020, 11:51 PM #3
    Howardc1001
    Howardc1001 is online now
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,725

    Re: Macro to clear Fill Coloured items only from row 9 in Col E

    Hi Rick.

    Thanks for the help

    Have tested you code and it works perfectly
    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] Macro to clear specific Items
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2019, 03:00 AM
  2. [SOLVED] Copy items where Col D has Fill colured items
    By flupsie in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-03-2018, 03:39 AM
  3. [SOLVED] Stop fill at last text in column B not the last coloured cell.
    By Wales MB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2013, 12:15 PM
  4. How can I count coloured cells (coloured using Conditional Formatting)
    By franfry in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-15-2013, 02:40 PM
  5. Too much formulas. Any limitations for coloured items?
    By toplisek in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2013, 09:48 AM
  6. [SOLVED] Macro to clear cell fill
    By ayvee0 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-31-2013, 02:24 PM
  7. I cannot add fill colour to any cell, or use coloured text
    By julianm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2006, 04:00 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