cfree36
Board Regular
- Joined
- Oct 5, 2005
- Messages
- 175
I am trying to delete all the rows with a 1 in a specified range
I was trying to use this code:
It runs but the rows with 1 in them do not delete?
I would appreciate any help here....
I was trying to use this code:
Code:
' For Each c In Sheets("sheet1").Range("FILTERRANGE")
' If c.Value = 1 Then
' c.Select
' Selection.EntireRow.Delete
' End If
' Next c
It runs but the rows with 1 in them do not delete?
I would appreciate any help here....