LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error message #N/A ISAF Media Analysis[_2_] Excel Discussion (Misc queries) 5 February 16th 09 12:34 PM
VBA Error Message "Compile Error...." Steve Excel Discussion (Misc queries) 3 July 15th 05 09:20 AM
changing the message in an error message The Villages DA Excel Worksheet Functions 2 February 18th 05 05:30 PM
How do I get rid of "Compile error in hidden module" error message David Excel Discussion (Misc queries) 4 January 21st 05 11:39 PM
please help with error message bruce forster Excel Programming 1 May 20th 04 09:28 PM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"