SAMCRO2014
Board Regular
- Joined
- Sep 3, 2015
- Messages
- 160
I am trying to create a loop that will clear the contents in column A if the value is less than 2904 OR contains any text.
I am struggling with the text portion of the loop. The text is different in each cell. This is what I have:
Dim LastRow2 As Long
LastRow2 = PLSR.Cells(Rows.Count, 2).End(xlUp).Row
For x = LastRow2 To 2 Step -1
If Cells(x, 1).Value < 2904 or Cells(x,1).Value = ????????
Cells(x, 1).ClearContents
End If
Next x
How do it look for ANY text? I only know how to look for specific text.
I am struggling with the text portion of the loop. The text is different in each cell. This is what I have:
Dim LastRow2 As Long
LastRow2 = PLSR.Cells(Rows.Count, 2).End(xlUp).Row
For x = LastRow2 To 2 Step -1
If Cells(x, 1).Value < 2904 or Cells(x,1).Value = ????????
Cells(x, 1).ClearContents
End If
Next x
How do it look for ANY text? I only know how to look for specific text.