|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
前辈们,如下问题,代码如下,为什么字典里面的关键字“用量”对应的item明明是5,而 x = d("用量")后,x的值一直为1,
Sub selectExcelfile()
Dim Wb As Variant
Dim aFile As Variant
Dim i&, Myr&, Arr, d
aFile = Application.GetOpenFilename("Excel 文件 (*.xlsx),*.xlsx")
''如果按“取消”键,则提示选择文件
'If aFile <> True Then
' MsgBox "请选择文件"
'End If
Set Wb = GetObject(aFile)
Set d = CreateObject("scripting.dictionary")
With Wb.Sheets("PCBA")
Myr = .[a65536].End(xlUp).Row
Arr = .Range("a1:p" & Myr)
For i = 1 To UBound(Arr, 2)
d(Arr(2, i)) = d(Arr(2, i)) + 1
Next
y = UBound(Arr, 1) - 1
x = d("用量")
Range("A1").Resize(y, 1).Value = .Cells(3, x).Resize(y, 1).Value
End With
Set d = Nothing
End Sub
|
|