Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
macro to select range from active cell range name string | Excel Programming | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
Select Sheet then Select Range | Excel Programming |