hi,

I´ve got a problem:
I programmed this sub:


Public Sub FalscherVorgang()

ArrayVorgangDefinieren
ArrayBausteinDefinieren
(these are the arrays i need to use further down)


Workbooks.Open("S:\SEKRETAR\Allgemein\Vorlagen\umwandlung zeiterf. öst-brd.xls")

For x = 5 To 981
Vorgangvorgabe(x) = Workbooks(3).Worksheets("Umrechentabelle").Cells(x, 1)
Next x

For y = 5 To 981
Bausteinvorgabe(y) = Workbooks(3).Worksheets("Umrechentabelle").Cells(y, 2)
Next y


for w = 5 To 981
If (Vorgang(0) = Vorgangvorgabe(w)) Then
Else
If (Vorgang(1) = Vorgangvorgabe(w)) Then
Else

and so on......

Else
MsgBox ("There is a mistake")

Next w

the problem is that it always displays the message box.....
even if i put a valid number in the Vorgang(0)-field and display a message-box if the values match, the mistake-msgbox is displayed.

can anybody help me?

thx, alex