|
- Sub aaa()
- '关闭屏幕更新
- Application.ScreenUpdating = False
- Dim r&, arr() As String, m As Long
- '从5行开始循环,一直到G列行最后一行数据所在的行号
- For r = 5 To Range("G65536").End(3).Row
- 'M列R行是否为空
- If Cells(r, "M") <> "" Then
- 'P列R行赋值 (G列R行 / H列R行 * I列R行)& M列R行
- Cells(r, "P") = "(" & Cells(r, "G") & "/" & Cells(r, "H") & "*" & Cells(r, "I") & ")" & Cells(r, "M")
- m = m + 1
- '动态数组,扩维
- ReDim Preserve arr(1 To m)
- 'P列值存入数组
- arr(m) = Cells(r, "P").Value
- Debug.Print "m:" & m
- End If
- Next
- '打开工作簿B.XLS
- Workbooks.Open Filename:=ThisWorkbook.Path & "\B.xls"
- '把生成的数组元素转换成用“,”连接的字符写主F8
- '这里有BUG,万一数组没有数据需要考虑
- Range("F8") = Join(arr, ",")
- '打开屏幕更新
- Application.ScreenUpdating = True
- End Sub
复制代码 你看立即窗口输出的M值。
|
|