
[問題] VBA不用函數尋求max min


這是點下去的結果
http://i.imgur.com/XeDQUoT.jpg


就是在1000隨機亂數中尋求最大小值及其個數
目前用函數寫很簡單
就是現在要改用
.cells if else
For next
迴圈的寫法
有點沒頭緒
想問有大大們能給點提示嗎
感謝
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 117.19.131.208
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1491981742.A.1C9.html
→
04/12 15:41, , 1F
04/12 15:41, 1F
→
04/12 15:42, , 2F
04/12 15:42, 2F
→
04/12 15:43, , 3F
04/12 15:43, 3F
→
04/12 15:43, , 4F
04/12 15:43, 4F
→
04/12 18:01, , 5F
04/12 18:01, 5F
→
04/12 18:01, , 6F
04/12 18:01, 6F
→
04/12 18:06, , 7F
04/12 18:06, 7F
→
04/12 18:06, , 8F
04/12 18:06, 8F
→
04/12 18:17, , 9F
04/12 18:17, 9F
→
04/12 19:19, , 10F
04/12 19:19, 10F

→
04/12 19:19, , 11F
04/12 19:19, 11F

→
04/12 19:19, , 12F
04/12 19:19, 12F
→
04/12 19:19, , 13F
04/12 19:19, 13F
→
04/12 19:54, , 14F
04/12 19:54, 14F
Office 近期熱門文章
PTT數位生活區 即時熱門文章