2,462
社区成员
发帖
与我相关
我的任务
分享
Sub 获取目标单元格的值()
Dim rng As Range
Set rng = [a1:z10]
Dim rg1 As Range, rg2 As Range
For Each rg1 In rng
If rg1.Interior.Color = RGB(0, 0, 0) Then
For Each rg2 In Intersect(rng, Columns(rg1.Column - 1))
If rg2.Interior.Color = RGB(255, 255, 0) Then
rg2.Select
MsgBox "目标单元格地址为:" & rg2.Address & ";值为:" & rg2.Value
End If
Next
End If
Next
End Sub