点击文件名下载附件
在学习VBA80集第24集时遇到了一段代码主要是关于引号的,不懂请大家帮助.
Sub c()
Dim arr, t
Dim x As Integer
Dim sr As String, sr1 As String
arr = Range("d2:d" & Range("a65536").End(xlUp).Row)
For x = 1 To UBound(arr)
If arr(x, 1) > 500 Then
sr1 = sr
sr = sr & "a" & x + 1 & ":d" & x + 1 & ","
End If
Next x
End Sub
从本地窗口看连接后的sr="a2:d2,a7:d7,"
问题1:引号从何而来?
问题2:为什么连接后不是sr="a2:d2",a7:d7呢?