View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jrh jrh is offline
external usenet poster
 
Posts: 14
Default Personal Settings Causing Error?

Two of us at work use a few macros
successfully. Another person always gets an error message
when running a do while loop in any of the macros : "Run
time error '9':
Subscript out of range".

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? It can't be the paths or anthing like that
because the macros work on our computers and the same
paths work for this person when there isn't a do while
loop in the particualar macro.

It is something with the do while loop for this person.
Thank you.