VBA Else statement is not working

[Sun11]

Hi Members,

I have this following code where, I tested it in all way, I feel the Else part of the coding is not working. Please help me to highlight where is the problem in this code. Why it does not coming in Else part.

Regards
Sun.

STEP1 = Calculation
If (condition) Then STEP2 = STEP1 - 1 Else STEP2 = STEP1
STEP3 = Calculation
STEP4 = Calculation
STEP5 = Calculation
STEP6 = Calculation
If (condition) Then
Y1 = Calculation
Y2 = Calculation
Y3 = Calculation
Y4 = Calculation
STEP7 = Y4
Else
STEP7 = Calculation


End If
Result = STEP7

 

[Sun11]

Hi MarcelBeug & GTO,

Thank you for correcting me & putting patience with me, It was a silly mistake of "& operator". I changed it into And & it worked.

Regards

 

[MarcelBeug]

You're welcome.