Hi All,

I'm trying to incoperate an array function into my script where when A condition is triggered it will save the contents of the selected cells in an array. Is this possible? This is what Ive got so far:

Code:
P = 2

Dim StudentName(i) As String


While Not IsEmpty(Cells(P, 1))

ActiveSheet.Range(Cells(2, 1), Cells(P, 11)).Select

If Cells(P, 11) <= 0 Then
StudentName(i) = Cells(P, 1)
InputBox (StudentName(i))
End If
P = P + 1


Wend

InputBox (StudentName(1))

Now, the InputBox (StudentName(i)) works inside the if statement, but the InputBox (StudentName(1)) doesnt.



Anyone got ant ideas?


Cheers,
Matt