作者查詢 / Iories
作者 Iories 在 PTT [ Visual_Basic ] 看板的留言(推文), 共20則
限定看板:Visual_Basic
看板排序:
全部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)
2F→: https://www.automateexcel.com/vba/open-file-dialog/12/15 08:08
1F→: myRow = shet1.range("A1").end(xldown).row05/27 10:20
2F→: shet1.range("H2:N" & myRow).Copy05/27 10:20
1F→: 亂猜的 改成SELECT N'中文'04/22 12:31
1F→: 工作表1 改成 sheets("工作表1")01/21 14:29
5F推: 看不懂 先推再說03/12 13:42
4F推: 剛測了一下,copy出來的圖表一樣是用名稱管理員03/13 16:32
5F→: 並沒有變成絕對座標 (Excel 2013)03/13 16:33
6F→: 抱歉,是直接copy圖表03/13 16:34
8F推: 直接在Autocad裡面用Autolisp寫也能輸入參數啊...03/13 16:21
1F推: 先確認 Sheets(1).Cells(1, 2).Value12/05 06:37
2F→: Sheets(1).Cells(1, 3).Value 的值都是正確的12/05 06:37
3F→: 資料頁裡有要找的值嗎?沒有的話就沒有回傳值12/05 06:38
4F→: 當然就不能copy (沒有row)12/05 06:38
1F→: 路徑 ActiveWorkbook.Path 檔名 ActiveWorkbook.Name02/24 10:43
1F→: 按鈕是Shape的話可以用Shape.OnAction查到巨集名稱12/04 21:10