Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jaymz Brown   on Oct 20 In MS Office Category.

  
Question Answered By: Adalwine Fischer   on Oct 20

When evaluating rows  to delete  I have found it best to work
from the bottom of the range up.

Copy, paste and modify the following into your Subroutine.

Dim i, c As Double
c = Range("A65536").End(xlUp).Row

For i = c To 1 Step -1
If Cells(i, x) > 299 or Cells(i, x) < 200 Then
Rows(i).Delete Shift:=xlUp
End If
Next

*where x is the column number that rev_org can be found

Share: 

 
 
Didn't find what you were looking for? Find more on Need help w/creating macro to delete rows Or get search suggestion and latest updates.


Tagged: