作者查詢 / Iories
作者 Iories 在 PTT [ Office ] 看板的留言(推文), 共82則
限定看板:Office
看板排序:
全部Oni_soul138TaiwanDrama120Free_box113Little-Games85Office82FORMULA173Gossiping49ChungLi31NTUDormM729NBA27iOS22NBA_Film22CFantasy20Visual_Basic20DeathNote15Baseball14KoreaDrama14NY-Yankees13Moto_GP11EatToDie10TW_Entertain10Database8Emulator8Lifeismoney8japanavgirls7Japandrama7CodeJob6Facebook6Golden-Award6Storage_Zone5Food4MayDay4movie4NTUacadem4TTOA4China-Drama3Elephants3IVE_STARSHIP3Kings3sex3Soft_Job3Taoyuan3Tech_Job3YuiAragaki3BLEACH2Cabal2EAseries2Instant_Mess2MAC2NSwitch2NtuDormM32StarCraft2A1-GP1Beauty1Boy-Girl1Broad_Band1C_Chat1Cavaliers1CCF1ChicagoBulls1CMWang1fastfood1FIFAseries1Game-Talk1Grizzlies1joke1KR_Entertain1KS94-3121Liu1LivingGoods1MLB1mobile-game1MobileComm1Motorsports1Nets1NFS1NTUdent941NTUMEB92-B1NTUMETA1NTUND931NTUND941Olympics_ISG1PCman1Pistons1PlayStation1studyteacher1StupidClown1SuperStarAve1Teacher1True-Escape1WorkinChina1<< 收起看板(91)
1F→: Workbooks("練習.xlsx").Close (False)06/02 18:37
1F→: https://stackoverflow.com/questions/55922404/11/22 20:25
8F→: 要保護自己的心血就不要用excel06/16 19:36
2F→: 寫一個Sub,在裡面call那個function,在Sub逐行跑06/13 07:51
3F→: 跑到進入Function06/13 07:52
6F→: 改用VBA抓資料,再鎖VBA02/15 07:05
2F推: stock/"&B1&"/%E7%.......08/21 16:16
3F→: 前後加引號失敗是因為多了空白08/21 16:17
1F→: 5:直接按F2?02/26 08:15
9F→: if Range("A1048576").End(xlUp).Row=1 then01/30 11:52
1F→: 第二個公式 U6*22.5% 改成 Min(U6*22.5%,3645)08/02 16:10
2F→: 另一個依此方式修改08/02 16:11
11F→: 把 b = a.Address 往下移三行(else 下一行)05/02 08:37