hello all,

I am creating a 2-D array that will be used to solve a truss problem. A user will specify certain boundary conditions for the Nodes of the truss. Based on those boundary conditions, certain rows and corresponding columns will be removed from the overall truss array. This will allow calculation of truss forces. I have a loop which goes through the boundary conditions for each node and determines if rows need to be deleted or not. The boundary conditions also specify nodal displacements or loads that will be found. 

For i = 1 To Nodes
    If BoundaryConditions(1, i) = "Hinge" Then
        Nodal_Disp(2 * i - 1) = 0
        'Remove row (2*i-1) and column(2*i-1) from stiffnessarray
        Nodal_Disp(2 * i) = 0
        'Remove row and colum from stiffnessarray
    ElseIf BoundaryConditions(1, i) = "Roller" Then
        Nodal_Disp(2 * i) = 0
        'Remove row and column from stiffness array
        Loads(2 * i - 1) = Range("$E$6").Offset(0, i - 1)
    Else
        Loads(2 * i - 1) = Range("$E$6").Offset(0, i - 1)
        Loads(2 * i) = Range("$E$6").Offset(1, i - 1)
    End If
Next i
Any help you could give me would be greatly appreciated