|
楼主 |
发表于 2011-9-29 09:17
|
显示全部楼层
回复 aa123456aa 的帖子
大侠如何让这段代码能自动运行,就是在名称位置输入名称后,会自动显示数据,而不用手动去运行代码。
我试着用
Private Sub Worksheet_Change(ByVal Target As Range)
Call AA
End Sub 来启动代码,可总是提示错误。请大侠再帮帮忙!
Sub AA()
Dim X%, Y%, Z%, M%, K%, G&, D
Set D = CreateObject("Scripting.Dictionary")
With Sheets("HOME首页")
Y = .Range("B65536").End(3).Row
ReDim ARR1(1 To Y - 2, 1 To 4)
arr = .Range("B3:B" & Y)
For Z = 2 To Sheets.Count
D.Add Sheets(Z).Range("C2").Value, Z
Next Z
For K = 1 To UBound(arr)
G = D.Item(arr(K, 1))
For M = 1 To 4
Set C = Sheets(G).Range("A1:Z65536").Find(.Cells(2, 2 + M), SearchFormat:=True)
If C Is Nothing Then
ARR1(K, M) = ""
Else
ARR1(K, M) = C.Offset(, 1).Value
End If
Next M
Next K
.Range("C3:F" & Y) = ARR1
End With
End Sub |
|