Thread: Error Message
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Error Message

Me and someone else at work use a few macros
successfully. Another person always gets an error message
when running one of the macros : "Run time error '9':
Subscript out of range". When you hit debug it is at a
point in the code where there is a do while loop :

Do While Workbooks("Roster For Macro").Sheets
("Roster").Cells(k, i) < ""

Would there be a reason why these macros (which all employ
a similar do while loop) do not work on this one person's
computer? We thought that maybe it was due to memory but
when the person signed on on another computer the same
thing happened so we thought it must be the personal set
up.

Thank you.