If then macro question

[warpedone]

For i = 1 to x
If i = 1 do something
If i = x do something else
if i is between 1 and x do something else entirely
Next i

My problem is in the If i is between 1 and x statement. All my i's are entering this if every time and it's recalculating w(1) and w(x).

The code I currently have that doesn't work is:
If 1 < i < x Then

 

[Seti]

How about something like this:

 For i= 1 to x
    If i = 1 then
        do something
    Elseif i = x then
        do another something 
    Else
        do a third thing  ' this will handle alll case of 1 < i < x
    End if
Next i

 

[warpedone]

Never mind....I figured it out.

 

[Juan Pablo González]

You can do it like

If i > 1 And i <x Then

but I would use either an ElseIf

If i = 1 Then

ElseIf i < x Then

Else

End If

or a Select Case statement

Select Case i
Case 1
   'Code
Case Is < x
   'Code
Case Else
   'Code
End Select