[算表] VBA函數.find錯誤訊息
軟體:excel
版本:2013
x = WorksheetFunction.Max(Range("C16", Cells(16, 26)))
c = Range("C16", Cells(16, 26)).Find(x).Column
MsgBox (c)
我想找出該列最大值在哪一欄
一直出現未設定物件或WITH區域變數的錯誤代碼
或是我有其他發法可以執行呢?
謝謝各位
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 61.65.54.155
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1489762721.A.A52.html
→
03/17 23:16, , 1F
03/17 23:16, 1F
→
03/17 23:17, , 2F
03/17 23:17, 2F
→
03/17 23:27, , 3F
03/17 23:27, 3F
→
03/17 23:27, , 4F
03/17 23:27, 4F
→
03/17 23:29, , 5F
03/17 23:29, 5F
→
03/17 23:29, , 6F
03/17 23:29, 6F
→
03/18 00:46, , 7F
03/18 00:46, 7F
→
03/18 00:48, , 8F
03/18 00:48, 8F
→
03/18 00:50, , 9F
03/18 00:50, 9F
→
03/18 00:58, , 10F
03/18 00:58, 10F
→
03/18 01:02, , 11F
03/18 01:02, 11F
→
03/18 01:03, , 12F
03/18 01:03, 12F
→
03/18 01:08, , 13F
03/18 01:08, 13F
※ 編輯: o1o3o1o31030 (1.164.137.2), 03/18/2017 01:08:20
→
03/18 01:08, , 14F
03/18 01:08, 14F
→
03/18 01:10, , 15F
03/18 01:10, 15F
→
03/18 01:12, , 16F
03/18 01:12, 16F
→
03/18 01:13, , 17F
03/18 01:13, 17F
→
03/18 01:20, , 18F
03/18 01:20, 18F
→
03/18 01:23, , 19F
03/18 01:23, 19F
→
03/18 01:38, , 20F
03/18 01:38, 20F
→
03/18 01:52, , 21F
03/18 01:52, 21F
→
03/18 01:52, , 22F
03/18 01:52, 22F
→
03/18 02:18, , 23F
03/18 02:18, 23F
→
03/18 10:23, , 24F
03/18 10:23, 24F
→
03/18 20:58, , 25F
03/18 20:58, 25F
→
03/18 20:59, , 26F
03/18 20:59, 26F
推
03/18 21:05, , 27F
03/18 21:05, 27F
→
03/18 21:05, , 28F
03/18 21:05, 28F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
