How can I delete a row based on Columns H and I

Discussion in 'Microsoft Excel Programming' started by ICSAnalyst, Nov 15, 2004.

  1. ICSAnalyst

    ICSAnalyst Guest

    ICSAnalyst, Nov 15, 2004
    #1

    1. Advertisements

  2. ICSAnalyst

    anilsolipuram Guest

    Sub Macro5()
    '
    ' Macro5 Macro
    ' Macro recorded 11/15/2004 by RXVP
    '

    '
    Dim t As Integer
    Dim b As Boolean
    b = True
    While b
    t = t + 1
    If Range("a" & t).Value = "" Then
    b = False
    Else
    If (Range("h" & t).Value = "0" And Range("i" & t).Value = "0"
    Then
    Rows(t & ":" & t).Select
    Selection.Delete Shift:=xlUp
    End If
    End If
    Wend
    End Su

    --
    anilsolipura
    -----------------------------------------------------------------------
    anilsolipuram's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1627
    View this thread: http://www.excelforum.com/showthread.php?threadid=27872
     
    anilsolipuram, Nov 15, 2004
    #2

    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Annette

    Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete t

    Annette, Sep 20, 2004, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    808
    Annette
    Sep 21, 2004
  2. ICSAnalyst

    How can I delete a row based on Columns H and I

    ICSAnalyst, Nov 15, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    188
    R.VENKATARAMAN
    Nov 16, 2004

  3. Delete Row Based On Row Height

    , Jan 12, 2005, in forum: Microsoft Excel Programming
    Replies:
    10
    Views:
    442
    Jan 13, 2005
  4. Guest

    Can I conditionally delete row in Excel? (if B3=0 delete row B)

    Guest, Jan 22, 2006, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    3,377
    Guest
    Jan 23, 2006
  5. Kris

    Delete Row Based On Two Columns

    Kris, Jul 4, 2006, in forum: Microsoft Excel Programming
    Replies:
    8
    Views:
    190
    Guest
    Jul 6, 2006
  6. AD108

    delete row based on value of cell in row

    AD108, Jul 30, 2006, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    320
    raypayette
    Jul 30, 2006
  7. Les Stout

    Delete row if 3 columns have empty cells in a row

    Les Stout, Apr 18, 2007, in forum: Microsoft Excel Programming
    Replies:
    7
    Views:
    298
    Les Stout
    Apr 18, 2007
  8. Chris Maddogz

    Retrieving Current Row,Columns & copying Format from Row,Columns a

    Chris Maddogz, May 28, 2009, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    258
    Chris Maddogz
    May 28, 2009
Loading...