00:09:08 ! tatsu114 (Quit: Leaving...) 00:38:09 ! SriVidyut (Ping timeout: 248 seconds) 00:42:13 Morris -> MorrisZZZ 00:48:34 ! LizardMen (Quit: このわたくしが 負 けるなんて、ありえませんわ!) 01:15:22 ! aspha (Quit: See you...) 01:16:50 + SriVidyut (SriVidyut!SriVidyut@mno1-ppp2231.docomo.sannet.ne.jp) to #ぱそ@cre 02:09:31 ! mjolnir2k (Quit: Leaving...) 03:12:19 ! Balyoshi (Ping timeout: 256 seconds) 06:36:22 + SiIdeKei (SiIdeKei!SiIdeKei@server129.janis.or.jp) to #ぱそ@cre 06:36:22 ! SiIdeKei_ (Read error: Connection reset by peer) 06:36:35 Mode by aba[AWAY]: #ぱそ@cre +o SiIdeKei 07:00:48 + SiIdeKei_ (SiIdeKei_!SiIdeKei@server129.janis.or.jp) to #ぱそ@cre 07:00:49 ! SiIdeKei (Write error: Connection reset by peer) 07:00:55 Mode by aba[AWAY]: #ぱそ@cre +o SiIdeKei_ 07:25:30 MorrisZZZ -> Morris 07:26:34 + Cat-Tail_UXG_ (Cat-Tail_UXG_!Cat-Tail@pa8a7c2.miygnt01.ap.so-net.ne.jp) to #ぱそ@cre 07:32:26 + SiIdeKei (SiIdeKei!SiIdeKei@server129.janis.or.jp) to #ぱそ@cre 07:32:26 ! SiIdeKei_ (Read error: Connection reset by peer) 07:32:41 Mode by aba[AWAY]: #ぱそ@cre +o SiIdeKei 07:54:59 Morris -> MorrisWork 08:36:53 + Balyoshi (Balyoshi!username@k161241.ppp.asahi-net.or.jp) to #ぱそ@cre 08:36:59 Mode by aba[AWAY]: #ぱそ@cre +o Balyoshi 09:56:41 raa0121_z -> raa0121 10:36:41 koi-chan[away] -> koi-chan 10:39:39 ! koi-chan (Quit: Leaving...) 10:39:47 + koi-chan[work] (koi-chan[work]!koi-chan@p1013237-ipngn12301marunouchi.tokyo.ocn.ne.jp) to #ぱそ@cre 10:40:45 Mode by Toybox: #ぱそ@cre +o koi-chan[work] 10:41:06 Mode by koi-chanSRV: #ぱそ@cre +o koi-chan[work] 10:48:07 ! koi-chanSRV (Quit: Leaving...) 11:10:09 ! SriVidyut (Ping timeout: 248 seconds) 11:38:05 + SiIdeKei_ (SiIdeKei_!SiIdeKei@server129.janis.or.jp) to #ぱそ@cre 11:38:05 ! SiIdeKei (Read error: Connection reset by peer) 11:38:16 Mode by aba[AWAY]: #ぱそ@cre +o SiIdeKei_ 11:39:51 ! koi-chan[work] (Ping timeout: 260 seconds) 11:55:02 + koi-chan[work] (koi-chan[work]!koi-chan@p1013237-ipngn12301marunouchi.tokyo.ocn.ne.jp) to #ぱそ@cre 12:00:39 + koi-chan[away] (koi-chan[away]!koi-chan@p1013237-ipngn12301marunouchi.tokyo.ocn.ne.jp) to #ぱそ@cre 12:02:36 ! koi-chan[work] (Ping timeout: 260 seconds) 12:04:34 + koi-chanSRV (koi-chanSRV!koi-chan@p1013237-ipngn12301marunouchi.tokyo.ocn.ne.jp) to #ぱそ@cre 12:08:03 + SiIdeKei (SiIdeKei!SiIdeKei@server129.janis.or.jp) to #ぱそ@cre 12:08:03 ! SiIdeKei_ (Read error: Connection reset by peer) 12:08:18 Mode by aba[AWAY]: #ぱそ@cre +o SiIdeKei 12:35:01 Mode by Toybox: #ぱそ@cre +oo koi-chanSRV koi-chan[away] 12:51:20 + koi-chan[work] (koi-chan[work]!koi-chan@106.171.85.181) to #ぱそ@cre 12:52:00 + koi-chan[work]0 (koi-chan[work]0!koi-chan@p1013237-ipngn12301marunouchi.tokyo.ocn.ne.jp) to #ぱそ@cre 12:52:28 Mode by Toybox: #ぱそ@cre +o koi-chan[work]0 12:56:16 ! koi-chan[work] (Ping timeout: 260 seconds) 12:58:34 ! koi-chan[work]0 (Quit: 回線切り替え―) 12:58:37 koi-chan[away] -> koi-chan 14:02:36 + Prof_M (Prof_M!moriarty@i219-167-215-177.s02.a004.ap.plala.or.jp) to #ぱそ@cre 14:02:50 Mode by aba[AWAY]: #ぱそ@cre +o Prof_M 14:03:29 ! Prof_M_ (Ping timeout: 248 seconds) 14:05:56 + Prof_M_ (Prof_M_!moriarty@i220-99-244-77.s02.a004.ap.plala.or.jp) to #ぱそ@cre 14:06:06 Mode by aba[AWAY]: #ぱそ@cre +o Prof_M_ 14:07:45 ! Prof_M (Ping timeout: 248 seconds) 14:08:35 + Prof_M (Prof_M!moriarty@i219-167-215-177.s02.a004.ap.plala.or.jp) to #ぱそ@cre 14:08:40 Mode by aba[AWAY]: #ぱそ@cre +o Prof_M 14:11:17 ! Prof_M_ (Ping timeout: 265 seconds) 15:49:26 + SriVidyut (SriVidyut!SriVidyut@mno1-ppp2231.docomo.sannet.ne.jp) to #ぱそ@cre 15:53:15 ! kairi (Quit: See you...) 17:17:20 MorrisWork -> Morris 17:18:26 ExcelVBAでしょうもないミスで1時間潰したという愚痴 17:18:54 エラーの原因が全然つかめなかった 17:19:21 簡単に書くと、Range(Cells(a,b),Cells(c,d))でエラーになる 17:19:55 あーだこーだ試しても解決できなかったけど、ふと変数宣言部を見ると 17:19:59 Dim d as String 17:20:01 orz 17:20:21 あまりにもアホすぎて一気に脱力 17:20:46 こんなに錆び付いていたのかと。 17:31:32 まぁ久々ならそんなこともあるさー 17:45:59 イキロ……。(´・ω・`)つ(´・ω・`) 17:46:33 koi-chan -> koi-chan[away] 17:46:59 1時間ならまだ… 17:49:47 Debug.Printしてもちゃんと数値なのよね 17:50:19 ただ、後から考えれば、先頭に符号用の余白1桁が空いてなかったわけだけど 17:51:11 「セルの列番号の指定に文字列型変数」が原因だったので 17:51:25 その行であれこれ試しても解決しない 17:51:58 ウォッチ式ウィンドウで追っかけてもちゃんと数字が入ってる(ように見える) 17:52:19 その横に「型:String」ってしっかり書いてあったのにねえ!orz 18:22:10 koi-chan[away] -> koi-chan 18:58:14 + aspha (aspha!UserID@p394002-ipngn200407otsu.shiga.ocn.ne.jp) to #ぱそ@cre 19:13:48 ! aspha (Quit: See you...) 19:31:29 + LizardMen (LizardMen!LZD@gc202-137-185-11.gctv.ne.jp) to #ぱそ@cre 20:08:30 + H_Aoi (H_Aoi!H_Aoi@182-165-208-149f1.hyg2.eonet.ne.jp) to #ぱそ@cre 20:42:52 + tatsu114 (tatsu114!tatsu114@ae107008.dynamic.ppp.asahi-net.or.jp) to #ぱそ@cre 20:54:10 ! H_Aoi (Quit: Leaving...) 21:01:09 ! Prof_M (Ping timeout: 265 seconds) 21:03:13 ! SriVidyut (Ping timeout: 248 seconds) 21:09:15 + akiraani_ (akiraani_!akiraani@KD036012047028.au-net.ne.jp) to #ぱそ@cre 21:12:23 ! akiraani (Ping timeout: 256 seconds) 21:22:52 + SriVidyut (SriVidyut!SriVidyut@mno1-ppp2231.docomo.sannet.ne.jp) to #ぱそ@cre 21:24:46 + Prof_M (Prof_M!moriarty@i219-164-98-122.s02.a004.ap.plala.or.jp) to #ぱそ@cre 21:24:58 Mode by aba[AWAY]: #ぱそ@cre +o Prof_M 21:37:31 + kairi (kairi!kairi@i121-117-132-253.s41.a030.ap.plala.or.jp) to #ぱそ@cre 22:49:40 + Yaduka (Yaduka!yaduka@KD106154110224.au-net.ne.jp) to #ぱそ@cre 22:51:50 ! Yaduka_ (Ping timeout: 265 seconds) 23:22:59 raa0121 -> raa0121_z 23:49:27 ! tatsu114 (Quit: Leaving...)