Hi I'm having some problems with a excel program (method 260). It was working ok yesterday, now a message pops up when I try to run the macros "Run time error '9': Subscript out of range. I'm only still learning excel so any help would be appreciated. This sheet was originally posted here quite some time ago.
Below is the highlighted area when debugged;

End If
If Sheets("Horse").Cells(A, B) <> vbNullString Then
Races(C) = Sheets("Horse").Cells(A, 1) & Sheets("Horse").Cells(X - 1, B).Text
Time(C) = Sheets("Horse").Cells(A, B)
C = C + 1

Cheers Bookend

Attached Files

Method_260 Auto.xls (167.5 KB, 862 views)