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

's Computer Specifications

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

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

's Computer Specifications

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...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=27872

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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