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

A

anilsolipuram

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
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I delete a row based on Columns H and I 1
VBA to match Cell Colour to another Cell 1
Deleting blank cells 2
Copy columns to free space in diff wrkbk 4
Insert Columns based on cell value 2
Macro if greater than letter then delete 11
Moving a row to new work sheet/book if order=yes 2
Deleting rows based upon Error conditions 1

Top