Results 1 to 5 of 5

Deleting row's based on a column's value... pls help

Threaded View

  1. #1
    Registered User
    Join Date
    11-05-2013
    Location
    new york
    MS-Off Ver
    Excel 2010
    Posts
    11

    Deleting row's based on a column's value... pls help

    hi everyone i am new to this fourms site and just wanted to say hi first

    my issue is simple, anything with a value of 0.00 in column H i want the entire row to be deleted.
    i thought i solved the issue but with my current code, but anything from 0.00 to 0.09 gets deleted. i just need 0 aka 0.00.

    take a look please


    Sub zerout()
    
    'THIS DELETES ALL ROWS WHERE THE VALUE IN COLUMN H IS "0.00"
        Dim FoundCell As Range
        Application.ScreenUpdating = False
        Set FoundCell = Range("H:H").Find(what:="0")
        Do Until FoundCell Is Nothing
            FoundCell.EntireRow.Delete
            Set FoundCell = Range("H:H").FindNext
        Loop
    
    End Sub
    [table="width: 500"]


    can someone please help me out.. the end result is this: delete rows that have a value or 0.00 in column H. if it matters column H is formatted with a number value.
    Last edited by alansidman; 11-05-2013 at 09:09 PM. Reason: code tags added

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Deleting row based on date in particular column
    By aserle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2013, 05:57 AM
  2. [SOLVED] Deleting rows based on duplicates in one column only
    By KD70 in forum Excel General
    Replies: 8
    Last Post: 10-12-2012, 03:07 PM
  3. Deleting data based on values in specific column
    By sgk18 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2012, 05:06 AM
  4. Deleting Dupliactions based on other column
    By blaketanon in forum Excel General
    Replies: 2
    Last Post: 11-03-2010, 04:17 PM
  5. Deleting a row based on a value in a column
    By Kai in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2005, 05:25 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