2nd July 2011, 10:18 AM
|
|
Member
|
|
Join Date: Nov 2006
Posts: 60
|
|
Help with excel
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
|