|
本帖最后由 zhu918918 于 2014-4-17 00:39 编辑
按附件给出的条件、要求,如何写代码。请老师们帮忙,谢谢老师!
我弄了好久不得结果。
- Sub Macro1()
- Dim arr, brr, i&, j&
- arr = [b10:b12]
- brr = Range("aa2:aa" & Cells(Rows.Count, "aa").End(xlUp).Row)
- For i = 1 To UBound(arr)
- For j = 1 To UBound(brr)
- If brr(j, 1) = "" Then GoTo line1
- If brr(j, 1) Mod 4 = arr(i, 1) Then brr(j, 1) = ""
- line1:
- Next
- Next
- Range("ab2").Resize(UBound(brr)) = brr
- End Sub
复制代码
|
|