Results 1 to 7 of 7

Thread: Removing Specific Fill Colors

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #7
    I tried executing base on the changes above but when I look at the output the cells that doesn't have text value(but has fill color) were not removed. Sorry if I'm not clear with my problem.

    For example if you look at the image below. The cells encircled with blue were correctly removed, but the fill color for those cells that doesn't have text value were not remove(Example, the one encircled with red). I wanted to remove the target fill colors in all sheets, regardless if they text or not.
    Capture.PNG

    I cant really think of any other way other than traversing my ws.UsedRange and checking if it has the target color(which is taking a looong time)
    Last edited by DivineKael; 07-21-2021 at 11:25 PM. Reason: Added additional info

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •