+ Reply to Thread
Results 1 to 3 of 3

VBA to delete rows with crireria

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VBA to delete rows with crireria

    Hello:

    Please refer to attached file.
    I have data as shown.
    I need to delete the rows with Null or zero value in column C,F and G.
    In this case highlighted rows will need to be deleted.

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: VBA to delete rows with crireria

    Try this

    Please Login or Register  to view this content.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VBA to delete rows with crireria

    Hello scottiex

    Thanks a lot, works

    Riz

+ 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. [SOLVED] SUM(SUMIFS(Multiple Crireria
    By KErasmus in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2019, 09:28 AM
  2. Rows delete formula as per range of cell values with counter to delete # rows
    By qureshi2016 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-03-2017, 09:35 AM
  3. Delete All Rows Below Criteria in Col A / Then Delete Specific Rows in Col E
    By LennyC91 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2016, 08:22 AM
  4. [SOLVED] CountIf formula with crireria
    By rizmomin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-13-2016, 07:13 PM
  5. Replies: 5
    Last Post: 11-12-2012, 08:38 PM
  6. Macro to delete certain columns and delete rows based on time in another column
    By beepbeep27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2012, 11:47 AM
  7. delete duplicate rows, delete empty rows
    By loade in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-03-2012, 05:42 AM

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