|
不知道怎么编辑,重新发一个帖子
假设b1:b30包含有错误值或者空行,我想忽略掉直接往下运行,麻烦老师们帮我看看这个代码怎么写
Sub c()
Dim x%
With Sheet1
For x = 1 To 30
If .Cells(x, b) = "" Then
x = x + 1
End If
.Cells(x, d) = "=VLOOKUP(b" & x & ",h:n,5)"
Next x
End With
End Sub
提示红色部分错误'13'类型不匹配,我把(x,b)改成(x,"B")不行,改成(x,2)也不行,请大家指点一下。
- Sub c()
- Dim x
- With Sheet1
- For x = 1 To 30
- If IsError(.Cells(x, "b")) Then GoTo 100 '另一种写法,跳转语句(如果是错误值,跳到100:语句)
- If Len(.Cells(x, "b")) = 0 Then GoTo 100
- .Cells(x, "d") = "=VLOOKUP(b" & x & ",h:n,5)"
- 100:
- Next x
- End With
- End Sub
复制代码
|
|