[VBA ] excel新手適作成績單問題 (以修正連結

看板Visual_Basic作者ReDmango (紅芒果)時間15年前 (2010/08/25 22:45)推噓1(1推 0噓 1→)

留言2則, 2人參與討論串1/1

http://ppt.cc/Uc0W 小弟初碰VBA 上面這個檔案內的巨集中的碼是 Sub 計算成績() For CLASS = 2 To 9 For PER = 3 To 8 For GRADE = 9 To 14 Worksheets(1).Cells(CLASS, 15) = Worksheets(1).Cells(PER, CLASS) * Worksheets(1).Cells(GRADE, CLASS) Next GRADE Next PER Next CLASS End Sub 可是他學期成績那一格一定是0 我有想過用 x= x+ Worksheets(1).Cells(PER, CLASS) * Worksheets(1).Cells(GRADE, CLASS) 來累加可是他會變成很詭異的數字耶~~ 該怎麼辦呢@@? 拜託各位強大的鄉民了!! --

推

wahb7610763

06/23 19:31,

06/23 19:31

→

newborner

06/23 19:32,

06/23 19:32

→

newborner

06/23 19:33,

06/23 19:33