ldy老师: 全国地区代码.XLS中 For i = 1 To UBound(arr) '遍历 d.Add arr(i, 1), arr(i, 2) '地名查邮编 d.Add arr(i, 2), arr(i, 1) '邮编查地名 If arr(i, 2) Like "##0000" Then d("all") = d("all") & "," & arr(i, 1) '省级 If Mid(arr(i, 2), 3) > "0000" Then '省级以下 If Right(arr(i, 2), 2) = "00" Then '地市级 Mid(arr(i, 2), 3, 4) = "0000" d(d(arr(i, 2))) = d(d(arr(i, 2))) & "," & arr(i, 1) '嵌套字典对象,反查 Else Mid(arr(i, 2), 5, 2) = "00" '县区级 d(d(arr(i, 2))) = d(d(arr(i, 2))) & "," & arr(i, 1) End If End If Next 真是搞的我晕头转向 另外: [a2:a40].Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:=Mid(d("all"), 2) '省份名称 这句也不太能理解 [em04][em04]
[此贴子已经被作者于2007-10-7 17:23:31编辑过] |