Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i created code in excel 2000 and it runs fine. i sent it to someone else
who has, i think, excel 97, possibly earlier, and it doesn't work. he gets 'run time error 13'. the code is short and simple and the only parts that could possibly not transfer into '97 are match or chr(10). Sub playersstats() myMessage = "" For i = 17 To 31 currentplayer = Sheets("input").Cells(i, 4) rowonsheet = Application.Match(currentplayer, Sheets("quotas").Range("a1:a5000"), 0) myMessage = myMessage & currentplayer & " : new quota: " & Sheets_("quotas").Cells(rowonsheet, 4) & Chr(10) & Chr(10) Next i MsgBox myMessage End Sub this seems to happen fairly often, where i can run code fine on my excel, but others (presumably w/ older excels) have problems. any ideas? thanks, mike allen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming |