+ Reply to Thread
Results 1 to 2 of 2

VBA to delete rows that are not highlighted

  1. #1
    Registered User
    Join Date
    09-18-2014
    Location
    England
    MS-Off Ver
    8
    Posts
    6

    VBA to delete rows that are not highlighted

    Hello,

    I was wondering if anyone could help me please? I've written a macro that creates an output highlighting the first cell in each column, that I would like to keep, in
    particular colours. I've used conditional formatting and it works perfectly. The only thing I need to do is delete all rows that don't have a background fill in the whole of column A (they have text in).

    I'm completely stuck and any help would be great

    Pablo

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: VBA to delete rows that are not highlighted

    It can be done, as long as the color applied in not Conditional Formatting and is a Regular Cell Color
    Cheers!
    Deep Dave

+ 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. Delete rows if cell is not highlighted
    By perdooky in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-10-2014, 10:38 AM
  2. [SOLVED] Delete non highlighted rows with macro
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-22-2013, 08:23 AM
  3. How do you delete all cells that are not highlighted
    By jakebanu in forum Excel General
    Replies: 2
    Last Post: 01-23-2013, 05:27 AM
  4. How do I delete the row when it has one cell highlighted?
    By Ashleyyy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-11-2012, 01:50 PM
  5. Delete highlighted Row
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2009, 11:43 AM
  6. [SOLVED] How do I delete all rows that contain no red highlighted data?
    By Linda Hudock in forum Excel General
    Replies: 7
    Last Post: 05-22-2006, 04:15 AM
  7. [SOLVED] How to delete rows when List toolbar's "delete" isnt highlighted?
    By Linda in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2005, 05:15 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