Subscript out of range
Stacy
You may have collected some "dirt" during
copying the line. Try deleting all empty space
to the left of the line or delete the whole line
and manually enter it again.
--
Best Regards
Leo Heuser
Followup to newsgroup only please.
"Stacy Haskins" skrev i en meddelelse
...
That doesn't seem to be the case. I have copied the line
from different procedures, and it works everywhere else.
Any other suggestions?
-----Original Message-----
Most likely because you don't have a visible sheet
named "StudentInfo" in
the active workbook. Check for typos, leading/trailing
spaces, etc. to make
sure that the spelling in the code is identical to the
spelling on the tab.
--
Vasant
"Stacy Haskins" wrote in message
...
Why am I getting a "subscript out of range" error in
the
following code?
Sub CheckSplits()
Sheets("Attendance").Select
If Range("X1") = "T" Then
SplitsOff
AttendanceSplitsOnOff = True
End If
ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1
Sheets("StudentInfo").Select <=****HERE****
If Range("X1") = "T" Then
SplitsOff
StudentInfoSplitsOnOff = True
End If
ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1
End Sub
.
|