作者查詢 / MOONRAKER
作者 MOONRAKER 在 PTT [ Visual_Basic ] 看板的留言(推文), 共3665則
限定看板:Visual_Basic
看板排序:
全部Military14258PHP3909Visual_Basic3665C_and_CPP3262Militarylife3191DummyHistory3066Physics2441Warfare2338Programming2035SF514SYSOP501marvel356bicycle354StarWars263sex203Network113Linux98hardware82Stock57java48C_Sharp44Gossiping41LTK29Soft_Job25Option24Browsers22Sub_CS18Web_Design18CodeJob16Flash14DC_SALE12MapleStory12Storage_Zone11PCSH91_30510PDA10Ajax9ForeignEX9GUNDAM9Singapore9sky9ComGame-Plan8Google8RegExp8Wikipedia8MOD7Navy7PC_Shopping7Road7C_Chat6Database6Electronics6Gamesale6HatePolitics6joke6PttSuggest6Violation6Chemistry5Key_Mou_Pad5KoreaStar5KS98-3025Office5Paradox5Tech_Job5Acad-Affairs4AntiVirus4bicycle-tour4biker4EAseries4ESP4ILSH-943134LCD4LightNovel4Marginalman4MP4pccu_physics4PttCurrent4TigerBlue4YiGo3114Bank_Service3comm_and_RF3Eclipse3FJU-EE-PIPO3FJU_physics3HelpBuy3Hsinchu3IA3IELTS3MdnCNhistory3MIS3MoveHouse3NTUSFA3pet3PttLifeLaw3Python3Rent_apart3StarTrek3TVCard3Windows3Army-Sir2Billiard2Cga2CSSE2EarthScience2L_TalkandCha2LoL2NCU97ME-B2NTU2NTUCGM2Railway2SMSlife2SportsShop2TaichungBun2Transport972TY_Research2YUGIOH2AC_In1ADS1Ancient1Android1AndroidDev1AppsForBBS1ASM1Aviation1Christianity1ck61st3081CntrbndList1cosplay1CS_TEACHER1CyberFormula1feminine_sex1FlashWolves1gallantry1GameDesign1GUNNM1happy1HCHS593131HCHS603091historia1image1Japan_Travel1japanavgirls1JunXin1Kaohsiung1Little-Games1ManUtd1MIS_Gbasket1MP3-player1NCCU_thanks1Notebook1NTNU-IAGS1NTUIM-081NTUMRC1NTUSG1phys851PttLaw1PublicServan1PunishRecord1Rozen_Maiden1San-X1Seiya1SFFamily1Simcity1SLG1Suckcomic1Taipei1THUIM-3rd1TKU_EW94B1TOEIC1Wargaming1wearefriends1WomenTalk1<< 收起看板(171)
1F→:那就對所有的<欄數>求出cells(<欄數>,<列數>)相加就好了12/03 16:24
2F→:這在VBA是很容易的,你多看一點書上的範例程式就會了12/03 16:25
1F→:我看不懂vlookup() 我認為他是微軟最整人的發明之一12/02 23:03
3F→:如果你是要先搜尋某個值所在格位,再用他的位置去讀取12/03 01:22
4F→:其他行內的資料,那在VBA是最簡單的事…別理vlookup了…12/03 01:22
1F→:event 裡面不就有了12/01 14:51
1F→:試試這個11/29 22:38
2F→:http://www.ozgrid.com/forum/showthread.php?t=3063711/29 22:38
4F→:大家都需要善用event啊…12/01 15:44
1F→:你引號怎麼左右不對稱啊11/29 17:47
4F→:那是.NET的。11/30 13:37
1F→:再用一個for i=1 to 1000包起來就是了11/28 11:19
3F→:空格不是Visual Basic會自動補上嗎11/28 01:42
8F→:editor不是會自動補上空格,怪哉。反正知道了就好了。11/28 23:34
3F→:用 & 吧,不要用 + 。11/27 21:46
1F→:請看 #18tZrVgg11/26 19:46
1F→:巨集就算寫得出來那內容會煩到死,用VBA比較快11/25 23:15