|
<p>Sub su()<br/> Dim k As Long, dd As Single<br/> While dd <= 10000<br/> k = k + 1<br/><font color="#f70938"> dd = dd + Cells(k, 1)</font> <br/> Wend<br/> MsgBox Cells(k - 1, 1).Address<br/>End Sub</p><p>如果A列的数值和小于10000,那么它就会一直循环下去,循环的结果是K>65536,而excel2003最大行数是65536,大于这个行数程序当然就会出错.<br/></p> |
|