换一种方式或许更简单
Sub 查找()
Dim sh As Range
For Each sh In Sheet1.Range("f1:f10")
k = k + 1
If sh.Value = "大米" And sh.Offset(0, 5).Value >= 300 Then
Range("p" & k) = sh.Offset(0, 5).Value
End If
Next
End Sub
换一种方式或许更简单
Sub 查找()
Dim sh As Range
For Each sh In Sheet1.Range("f1:f10")
k = k + 1
If sh.Value = "大米" And sh.Offset(0, 5).Value >= 300 Then
Range("p" & k) = sh.Offset(0, 5).Value
End If
Next
End Sub