You could do something like this:

'Assuming Column C is the one you are searching
'and has a heading.
Set SearchRange = Range("C2:C" & Range("C65536").End
(xlUp).Row)
For Each Cell In SearchRange
If Len(Cell.Value) 0 Then
If Cell.Value < "Size" And _
Cell.Value < "Grand Total" Then
Range(Cell.Offset(0, -2).Address & ":" &
Cell.Offset(0, -1).Address).Select
'Code to do what you're going to do to the two
cells.
End If
End If
Next Cell


Tod
-----Original Message-----

I need to search a Column for any cell that is

1. Not Blank
2. Not equal to "Size"
3. Not equal to "Grand Total"

Then select the TWO cells to its left.


.