Select Range
This should do it:
Sub Test()
Cells(2, 4) = 0
For i = 1 To 1000
If InStr(1, Cells(i, 1), "SAFEWAY", vbTextCompare) Then
Cells(2, 4) = Cells(2, 4) - Cells(i, 2)
End If
Next i
End Sub
Regards,
Per
On 16 Jun., 02:27, Ali wrote:
I want to select a cell that contain a specific word in it: I have
written as follow:
Sub Test()
Cells(2, 4) = 0
For i = 1 To 1000
If Cells(i, 1).Contain "SAFEWAY" Then
Cells(2, 4) = Cells(2, 4) - Cells(i, 2)
End If
Next i
End Sub
*But it does't work
could you please make it correct for me.
Thanks
Ali
|