作者查詢 / andy90498

總覽項目：發文 | 留言 | 暱稱

作者 andy90498 在 PTT [ Office ] 看板的留言(推文), 共18則

限定看板：Office

看板排序：

全部Gossiping16282ask5690Militarylife3856MobileComm1516Cga489PttEarnMoney404L_TalkandCha360GossipPicket277Lifeismoney270HatePolitics268MenTalk250HardwareSale244Storage_Zone201MRT164Mancare152About_Life149PC_Shopping136joke132Anti-Cancer129RO116CSMU-Talk114Chemistry100WomenTalk100CSMU-MT9992Android84PingTung84PttLifeLaw81YuiAragaki72Hate68digitalk63BNS61Salary61StupidClown47AntiVirus43creditcard39PublicIssue33gay32Examination26FuMouDiscuss26ID_Multi23LCD23Kaohsiung19Facebook18give18Office18PokeMon17battlegirlhs16C_Chat16guitar16Teacher16Broad_Band15AskBoard14YUGIOH14Marginalman13Army-Sir12biker12IA12mobilesales12PttNewhand12specialman12WinNT12Aries10Browsers10FamousWords10hardware10LoL10VideoCard10CVS9Windows9KOTDFansClub8OverClocking8SENIORHIGH8Test8car7historia7SYSOP7Taoyuan7Violation7Beauty6BoardCourt6Google6PublicServan6Python6sex6Sub_DigiTech6WindowsPhone6CSMU-MT985juniorhigh5PttLogo5Shu-Lin5ShuangHe5Steam5Stock5Tech_Job5TPC_Police5BoardAffairs4BuyTogether4CSMU-BK-ST4Diary4DotA24Jinmen4LAW4Lawyer4TaichungBun4Bank_Service3Boy-Girl3ChangHua3ChungLi3ComGame-Plan3CSMU-BASKET3CSMU-D993CSNT-BASKET3Doraemon3EngTalk3Jacky_Woo3L_LifeInfo3MayDay3NBA3points3Railway3studyteacher3Suit_Style3Tainan3YOLO3AfterPhD2AllTogether2BigBanciao2cat2consumer2CSMU-MED982csmumountain2DummyHistory2ForeignEX2HK-movie2home-sale2HsinChuang2hypermall2I-Lan2japanavgirls2L_GlobalView2L_PTTHealth2lesbian2LivingGoods2LTK2MapleStory2Medicine2Nantou2NTU2pharmacist2PttFamous2rent-exp2Road_Running2SMSlife2Taitung2TamShui2Aerobics1AngelPray1Anti-ramp1ArakawaCow1ArenaOfValor1BeautyBody1BigSanchung1book1Bus1CFantasy1Chan_Mou1Childhood1CMS_97_S3F1CSMU-CH1CSMU-MED971CSMU-MT891CSMU-MTSA1CultureShock1Digitalhome1DiscoveryNGC1dog1EarthQuake261EarthQuake431Economics1Employee1equal_change1facelift1FCU_Talk1FishShrimp1FITNESS1gallantry1Geography1Gov_owned1GuessX31hairdo1Hamster1HCU1HK-drama1HK_Comics1HomeTeach1Hsinchu1HsinYi1HSNU_8201Hunter1Instant_Mess1Insurance1iOS1JinYong1KanColle1kawaii1Key_Mou_Pad1kodomo1KS94-3201LawsuitSug1Little-Games1marvel1Math1Mechanical1Miaoli1Military1Minecraft1movie1MP1MuscleBeach1Nangang1nb-shopping1NCCU1nCoV20191NCUFingrad031Neihu1Nethood1NetSecurity1NSYSU1NTUHistory011Nurse1Old-Games1OriginalSong1pal1Pangya1Paul_52-1t1pay_home1PHAT-MEN1pighead1Plant1PlayStation1Post1QuestCenter1RealmOfValor1Rent_tao1San-Ying1Softball1soul1sp_teacher1Sub_DigiLife1Sub_Strategy1SuperHeroes1Supermission1talk1Thailand1TKU_EE_92C1TSU1TuCheng1TW-language1twin1UNT-FA1WarCraft1Women_Picket1WorkanTravel1Zhongshan1<< 收起看板(264)

首頁

尾頁

[問題] 關於office是否該買微軟的

[ Office ]10 留言, 推噓總分: +5

作者: dfg512 - 發表於 2021/05/25 22:07(2年前)

9^F推andy90498: 可以共通啊但是排版會跑掉你最後還是需要靠微軟的off05/27 15:08

10^F→andy90498: ice 來校正除非你的不需要校正排版05/27 15:08

[文件] 從EXCEL複製到TXT檔格式會跑掉

[ Office ]2 留言, 推噓總分: +1

作者: andy90498 - 發表於 2021/05/05 12:12(3年前)

2^F→andy90498: 感謝樓上提供的方式從WORD轉貼到記事本就解決了05/06 10:29

[算表] 如何用迴圈修改lebel的內容?

[ Office ]18 留言, 推噓總分: +1

作者: naniate - 發表於 2021/03/14 01:47(3年前)

1^F推andy90498: Lebel & i.capation ="" 這句改成03/14 02:06

2^F→andy90498: controls("Lebel" & i).capation =""03/14 02:06

3^F→andy90498: 你label也拼錯了03/14 02:08

[問題] word表格插入圖片

[ Office ]10 留言, 推噓總分: +1

作者: Beartrish - 發表於 2021/02/24 11:36(3年前)

1^F推andy90498: 插入文字方塊然後把圖片放進文字方塊然後把文字方塊02/24 14:09

2^F→andy90498: 的外框改成無色即可02/24 14:09

Fw: [請問] EXCEL VBA比對資料問題

[ Office ]14 留言, 推噓總分: +1

作者: andy90498 - 發表於 2021/02/23 17:48(3年前)

1^F→andy90498: 補充比對的部份我這樣寫02/23 16:33

2^F→andy90498: https://i.imgur.com/laF9o3d.png02/23 16:33

4^F→andy90498: 如果是格子很明顯不同的那不是本次的問題02/23 18:20

5^F→andy90498: 有問題的是格子資料皆相同但判讀卻有標色的那些02/23 18:21

6^F→andy90498: 謝謝各位花時間看到這邊02/23 18:21

9^F→andy90498: 目前找到一種解法是兩邊的工作格我把有問題的那幾格02/23 18:35

10^F→andy90498: 單純DELETE掉然後手動KEY回去他就正常了02/23 18:35

11^F→andy90498: 但數量這麼多實在很困擾剛剛又手動寫了一個讓程式02/23 18:35

12^F→andy90498: 刪除之後又key回去的VBA 結果反而沒用一定要人工02/23 18:36

16^F→andy90498: 我以為同一行用,隔開都會一起宣告成string 看樣子錯了02/23 19:06

首頁

尾頁