|
本帖最后由 晨雨1104 于 2016-8-12 17:32 编辑
初学者,请教各位老师判断语句中如何用变量循环
Sub t1()Dim x As Integer
For x = 2 To 8
If VBA.InStr(Range(Cells("x", 1), "")) Then
Cells("x", 2) = ""
Else
Cells("x", 2) = ""
End If
Next x
End Sub
晨雨1104 发表于 2016-8-12 16:23
谢谢你的回复,这样是做出来了,很感谢。但如果我要同时把里面别的不是“辛丰”的内容改成别的,可以做到 ...
Sub t1()
Dim x As Integer
For x = 2 To 8
If InStr(Cells(x, 1), "辛丰") Then
Cells(x, 2) = "辛丰"
ElseIf InStr(Cells(x, 1), "国信宜和") Then
Cells(x, 2) = "国和"
Else
Cells(x, 2) = ""
End If
Next
End Sub
|
|