+ Reply to Thread
Results 1 to 2 of 2

macro to remove rows with zeros in them

  1. 03-24-2009, 03:48 PM #1
    antonyjones101
    antonyjones101 is offline
    Registered User
    Join Date
    03-13-2009
    Location
    uk
    MS-Off Ver
    Excel 2003
    Posts
    14

    macro to remove rows with zeros in them

    Hi there I have a macro that pulls information from one sheet to another. I need to further sort through this information by hand. What I want to do is search row by row from row a and any rows that have 0 showing up in them I want that row deleting out. what's the easiest way to do this?
    Reply With QuoteRegister To Reply
  2. 03-24-2009, 03:53 PM #2
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: macro to remove rows with zeros in them

    Link should help. Post back if you need help

    http://www.rondebruin.nl/delete.htm

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1