Thread: why is my loop so slow?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Buffyslay Buffyslay is offline
external usenet poster
  
Posts: 40
Default why is my loop so slow?
what i need to do is delete any rows where col b = 0 or 2?


For conCat2 = 2 To iCountA
If ActiveCell.Value = 2 Then
ActiveCell.EntireRow.Delete
ElseIf ActiveCell.Value = 0 Then
ActiveCell.EntireRow.Delete

Else
ActiveCell.Offset(1, 0).Activate
End If
Next

Reply With QuoteReply With Quote