作者查詢 / bulldog
作者 bulldog 在 PTT [ Office ] 看板的留言(推文), 共497則
限定看板:Office
看板排序:
全部Office497ShuangHe61Shu-Lin59SongShan59CFAiafeFSA18Beauty17Visual_Basic17ONE_PIECE11MLB7sex7Wen-Shan7Insurance5share5PttCard4CPBL3mud3StupidClown3Baseball2EngTalk2NTPU-STATM932PCman2Prob_Solve2Tsao2A-Rod1BabyBears1ck55th3011ck61st3231CMWang1CYCUEL95A1dog1Facebook1Gossiping1Headphone1HSNU_10041HSNU_j1021Ikariam1joke1KG92-3131KS92-3121KS92-3191KS94-3071KS95-3181LinkinPark1LivingGoods1Nanofan1NBAGAME1NCCU03_FM1NCCU99_PSYCH1NCKU_ECO971NDHU-LS-SB1NTPU-STAT951NTUCH-901NTUST-EE-B911NTUT_CH585A1SMAP1Statistics1TAXI1tcfsh69th3201ToS1TRXradio1YP94-3131<< 收起看板(61)
2F推:我猜是這個http://support.microsoft.com/kb/21411809/13 23:31
4F→:用A1, B1取代D1{=STDEV(ROW(INDIRECT(A1&":"&B1)))}08/30 11:29
1F推:應該可以參考一下利用合併列印的方式?08/01 15:26
1F→:VBA應該沒有陣列方法,請用矩陣乘法處理...07/18 22:49
2F→:我也是XD, 矩陣乘法的話用MMult, 或者寫迴圈去處理吧07/19 13:22
2F推:Excel 2010 Power Programming with VBA 我覺得還不錯....07/06 10:25
4F→:那不是Week,是Day~07/04 23:09
1F推:第一列=DEC2HEX(63+ROW()) 往下拉就好了07/02 12:14
1F推:Key:=Range("move") 這個應該改成你要刪選的欄位06/26 08:45
2F→:說錯,應該是你要排序的欄位06/26 08:47
1F→:可以先按F1試著找看看答案,提示LookAt:=xlWhole06/21 19:45
1F→:Target.Cells(1,1)跟Cells(1,1)是不一樣的概念..06/19 15:14
2F→:Cells(1,1)是A1, 但是假設你的Target範圍是Range("A2:D3")06/19 15:17
3F→:那麼Target.Cells(1,1)就會是A2了06/19 15:17