PC Review

Thread Tools Rate Thread

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

Posts: n/a
      15th Nov 2004

PLEASE HELP.. It may cost me my job!!!!

ICSAnalyst's Profile: http://www.excelforum.com/member.php...o&userid=15095
View this thread: http://www.excelforum.com/showthread...hreadid=278729

Reply With Quote
Posts: n/a
      15th Nov 2004

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
If (Range("h" & t).Value = "0" And Range("i" & t).Value = "0"
Rows(t & ":" & t).Select
Selection.Delete Shift:=xlUp
End If
End If
End Su

anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=27872

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieving Current Row,Columns & copying Format from Row,Columns a Chris Maddogz Microsoft Excel Programming 2 28th May 2009 07:36 AM
Need to sum row 7 columns based row 8 columns that are not Blank Leew Microsoft Excel Worksheet Functions 3 27th May 2008 04:21 PM
How can I delete a row based on Columns H and I ICSAnalyst Microsoft Excel Programming 1 16th Nov 2004 11:19 AM
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below Annette Microsoft Excel Programming 2 21st Sep 2004 02:40 PM
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B Hannes Heckner Microsoft Excel Programming 1 5th Mar 2004 10:10 AM




All times are GMT +1. The time now is 10:07 PM.