vba 数组字符串答:Sub test()Dim arr() As String, brr() As String Dim crr() As String Dim i As Long, k As Long '随便定义了2个数据,按楼主说的,brr的所有元素在arr都存在 arr = Split("A,B,C,D,E,F,G", ",")brr = Split("B,D,G", ",")'用crr来存取 arr-brr的元素,crr的大小如下...
excel的vba中,已经得到一个数组,有什么语句可以为每个元素追加一个字...答:Sub ss_Error()Dim Arr(), i&, One Arr = Array("A", "B", "C") For Each One In Arr One = "=" & One Next OneEnd SubSub ss()Dim Arr(), i&, One Arr = Array("A", "B", "C") For i = 0 To UBound(Arr) Arr(i) = "=" & Arr(i) Next iEnd Sub注意...