|
- Sub mycheck()
- Dim x, z, i, ar, br()
- z = Range("d65536").End(3).Row
- ar = Range("d2:e" & z - 1)
- For x = 1 To UBound(ar)
- If Range("d" & z).Text & Range("e" & z).Text = ar(x, 1) & ar(x, 2) Then
- i = i + 1
- ReDim Preserve br(1 To i)
- br(i) = "D" & x + 1 & "E" & x + 1
- MsgBox "你输入的内容与 D" & x + 1 & "E" & x + 1 & "的名称&规格相同,请核对!"
- End If
- Next
- '******把相同的单元格地址记录在I列********
- Range("i:i").Clear
- Range("i1") = "输入内容相同单元格地址"
- Range("i2").Resize(i, 1) = Application.WorksheetFunction.Transpose(br)
- End Sub
复制代码
|
|