auch ne Variante
22.12.2010 10:20:33
Rudi
Sub ttt()
Dim var1, var2, var3, var4, var5, var6, var7, _
var8, var9, var10, var11, var12, var13, var14, _
var15, var16, var17, var18, var19, var20, var21
Dim oVar As Object, myVar
var1 = 1
var2 = 1
var3 = 3
var4 = 4
var5 = 5
var6 = 6
var7 = 7
var8 = 8
var9 = 9
var10 = 10
var11 = 11
var12 = 12
var13 = 13
var14 = 14
var15 = 15
var16 = 16
var17 = 17
var18 = 18
var19 = 19
var20 = 20
var21 = 21
Set oVar = CreateObject("Scripting.Dictionary")
For Each myVar In Array(var1, var2, var3, var4, var5, var6, var7, _
var8, var9, var10, var11, var12, var13, var14, _
var15, var16, var17, var18, var19, var20, var21)
oVar(myVar) = 0
Next
If oVar.Count = 21 Then
MsgBox "Alle unterschiedlich"
Else
MsgBox "Nicht alle unterschiedlich"
End If
End Sub
Gruß
Rudi