|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub lqxs()
- Dim Arr, i&, ad$
- Sheet1.Activate
- Arr = Sheet1.UsedRange
- For i = 4 To UBound(Arr)
- If Arr(i, 10) = "Format1" Then
- If Arr(i, 6) = "" Then ad = ad & Cells(i, 6).Address & vbCrLf
- ElseIf Arr(i, 10) = "Format2" Then
- If Arr(i, 6) <> "" Then ad = ad & Cells(i, 6).Address & vbCrLf
- End If
- If Arr(i, 3) = "" Then ad = ad & Cells(i, 3).Address & vbCrLf
- If Arr(i, 5) = "" Then ad = ad & Cells(i, 5).Address & vbCrLf
- Next
- If ad <> "" Then MsgBox ad Else MsgBox "Correct"
- End Sub
复制代码 |
|