View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Leo Heuser[_3_] Leo Heuser[_3_] is offline
external usenet poster
 
Posts: 109
Default 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



.