+ Reply to Thread
Results 1 to 6 of 6

Delete entire row for different color in VBA

  1. #1
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Delete entire row for different color in VBA

    Hi Guys

    In column A i have items details & in column B is the color of items.
    In an items there are multiple color,i want to keep the first color only & delete entire row of the others color.
    How can I do this in VBA?

    Untitled.jpg
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-29-2020
    Location
    Kraków, Poland
    MS-Off Ver
    Office 365
    Posts
    10

    Re: Delete entire row for different color in VBA

    Hello mehidy,

    Here's the code for you:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re: Delete entire row for different color in VBA

    Quote Originally Posted by Buskolsky View Post
    Hello mehidy,

    Here's the code for you:
    Please Login or Register  to view this content.
    Thanks a lot.
    How can I have the result in a new sheet?

  4. #4
    Registered User
    Join Date
    01-29-2020
    Location
    Kraków, Poland
    MS-Off Ver
    Office 365
    Posts
    10

    Re: Delete entire row for different color in VBA

    Mehidy,

    Posting the result in a new sheet can be done in several ways. Whether you want to create a new sheet every time you run a macro, add new lines to existing sheet or overwrite existing data - the approach will be different. Please be more precisive with your example and perhaps we may come up with something

  5. #5
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re: Delete entire row for different color in VBA

    Quote Originally Posted by Buskolsky View Post
    Mehidy,

    Posting the result in a new sheet can be done in several ways. Whether you want to create a new sheet every time you run a macro, add new lines to existing sheet or overwrite existing data - the approach will be different. Please be more precisive with your example and perhaps we may come up with something
    Hi,
    I want to create a new sheet with the result, every time I run this macro.

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,463

    Re: Delete entire row for different color in VBA

    Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
    Use the "Quick reply" instead
    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. Delete entire row based on text color? Format Macro?
    By Ron Purpura in forum Excel General
    Replies: 5
    Last Post: 05-31-2018, 04:33 PM
  2. iCell.EntireRow.Delete not working. Need code to Delete Entire Row
    By unit285 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-27-2017, 10:48 PM
  3. [SOLVED] Macro Needed to Delete Entire Row if the Entire Row (Or Col A,B,C,D in row ) are blank
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2016, 06:32 AM
  4. VBA code to delete the FILTERED range and moving the cell up (dont Delete entire row)
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2015, 07:48 AM
  5. Replies: 4
    Last Post: 10-12-2014, 08:54 AM
  6. [SOLVED] Delete cell only with certain critria. Don't want to delete entire row, the celsl only
    By RobertOHare in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2013, 04:18 AM
  7. Delete entire row when cell says delete
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-27-2007, 11:46 AM

Tags for this Thread

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