Good days everyone, can anyone help me on the row deletion when it meet the condition?
this is my code i had wrote:
when i use EntireRow.Hidden = True, it succesfully hide the rows according to the conditions, but the use .Delete, it just deleted some rows that met the condition instead of all of it. Thanks for concern and help.
this is my code i had wrote:
Code:
Dim count04 As Integer
For count04 = 5 To IR01 + 1
If Cells(count04, 23).Text = "break" Then Cells(count04, 23).Value = ""
If IsEmpty(Cells(count04 - 4, 6)) Or Cells(count04 - 4, 6).Text = "Mfg Name" Then Cells(count04 - 4, 6).EntireRow.Delete
Next count04when i use EntireRow.Hidden = True, it succesfully hide the rows according to the conditions, but the use .Delete, it just deleted some rows that met the condition instead of all of it. Thanks for concern and help.
