VBA如何找出2个数组中不同的元素,并列出~求代码~谢谢~

[复制链接]
查看11 | 回复3 | 2011-3-20 13:44:47 | 显示全部楼层 |阅读模式
Public Sub ssss()Dim arr1(1 To 5) As Integer, arr2(1 To 5) As Integer, iFor i = 1 To 5
arr1(i) = i
arr2(i) = i + 2Next'----下面开始----Dim s1$, s2$, t$s1 = " "s2 = " "For i = LBound(arr1) To UBound(arr1)
s1 = s1 & arr1(i) & " "NextFor i = LBound(arr2) To UBound(arr2)
s2 = s2 & arr2(i) & " " ...
回复

使用道具 举报

千问 | 2011-3-20 13:44:47 | 显示全部楼层
当然你也可以用for 双重循环判断!...
回复

使用道具 举报

千问 | 2011-3-20 13:44:47 | 显示全部楼层
Option ExplicitOption Base 0Private Sub Command1_Click()Dim arr1, arr2, dic As Object, i%, arr3arr1 = Array(1, 2, 3)arr2 = Array(2, 3, 4)Set dic = CreateObject("Scrip...
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行