troelsi
11-26-2007, 05:54 AM
Hi
I have to sets.
Set Pr is the universal set.
Set Pf i a subset of pr.
In case my data isn't sorted properly I would like to examine wheter the variable in question is part of PF.
For p = 1 To UBound(pr)
For i = 1 To UBound(pf)
If pf(i) = pr(p) Then
PisaPartofPF=1
end if
next i
next p
The above method seems a bit slow and heavy is there a better way to handle sets?
I have to sets.
Set Pr is the universal set.
Set Pf i a subset of pr.
In case my data isn't sorted properly I would like to examine wheter the variable in question is part of PF.
For p = 1 To UBound(pr)
For i = 1 To UBound(pf)
If pf(i) = pr(p) Then
PisaPartofPF=1
end if
next i
next p
The above method seems a bit slow and heavy is there a better way to handle sets?