Results 1 to 13 of 13

Delete rows based on a condition

Threaded View

sakinen Delete rows based on a... 07-20-2009, 02:59 AM
romperstomper Re: Delete rows based on a... 07-20-2009, 03:36 AM
D_Rennie Re: Delete rows based on a... 07-20-2009, 03:37 AM
D_Rennie Re: Delete rows based on a... 07-20-2009, 03:45 AM
romperstomper Re: Delete rows based on a... 07-20-2009, 03:51 AM
D_Rennie Re: Delete rows based on a... 07-20-2009, 04:05 AM
romperstomper Re: Delete rows based on a... 07-20-2009, 04:20 AM
D_Rennie Re: Delete rows based on a... 07-20-2009, 04:43 AM
sakinen Re: Delete rows based on a... 07-20-2009, 06:12 AM
D_Rennie Re: Delete rows based on a... 07-20-2009, 07:30 AM
sakinen Re: Delete rows based on a... 07-20-2009, 07:57 AM
D_Rennie Re: Delete rows based on a... 07-20-2009, 08:14 AM
sakinen Re: Delete rows based on a... 07-20-2009, 09:14 AM
  1. #1
    Registered User
    Join Date
    06-20-2009
    Location
    Belgrade, Serbia
    MS-Off Ver
    Excel 2007
    Posts
    35

    Delete rows based on a condition

    Is it posibile to make a macro that automaticaly delete rows based ona a condition. Condition is to delete rows that have B column value "" or zero. For example:

    ....A B C .....
    1. 1 2 5
    2. 2
    3. 3 4
    4. 6
    5. 5 7

    Rows that has to be deleted are 2 and 4.
    Thanks in advance.
    Last edited by sakinen; 07-20-2009 at 09:14 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1