シート移動をロックするマクロの調査Ver2

難しー!

結局、シートAは参照(SelectとEnd)しているだけですので、

別の手段で何とかクリアしました。m(__)m

明日からOFF(11連休)なので休憩します。

 

Range("Wawawa").Select

  

range_count  =  Range("Wawawa").Count

 

2.

Set oFndRange = Worksheets("Wawawa").Columns("B:B").End(xlDown)

  

oRange_B1 = ThisComponent.getSheets().getByName("Wawawa").getCellRangeByName("B1")

oCursor = ThisComponent.getSheets().getByName("Wawawa").createCursorByRange(oRange_B1)

oCursor.collapseToCurrentRegion

cellRange = oCursor.getRows.Count


 

コメントをお書きください

コメント: 6
  • #1

    buytadalafilonline (水曜日, 07 11月 2012 00:21)

    I intended to draft you this bit of remark in order to say thank you once again for the pretty guidelines you've documented here. It is quite strangely open-handed of you to present unhampered precisely what a lot of people could have made available as an electronic book to generate some cash for themselves, and in particular now that you could have tried it if you decided. Those good tips likewise served as a good way to recognize that some people have a similar dream the same as my personal own to understand a whole lot more concerning this condition. I am sure there are lots of more fun periods ahead for many who take a look at your website.

  • #2

    淫インモラル (水曜日, 15 1月 2014 17:52)

    淫インモラル:http://www.hikanpou.com/product/immoral.html
    妖姫:http://www.hikanpou.com/product/youhi.html
    VigRx:http://www.hikanpou.com/product/VigRx.html
    巨人倍増:http://www.hikanpou.com/product/巨人倍増.html
    VigRx:http://www.hikanpou.com/product/VigRx.html
    花痴:http://www.hikanpou.com/product/花痴.html
    紅蜘蛛:http://www.hikanpou.com/product/紅蜘蛛.html
    D10媚薬:http://www.hikanpou.com/product/D10.html
    三便宝:http://www.hikanpou.com/product/三便宝.html
    D10催情剤:http://www.hikanpou.com/product/D10.html
    蟻力神:http://www.hikanpou.com/product/蟻力神1.html
    五便宝:http://www.hikanpou.com/product/五便宝.html
    妖姫:http://www.hikanpou.com/product/youhi.html
    淫インモラル:http://www.hikanpou.com/product/immoral.html
    淫インモラル:http://www.hikanpou.com/product/immoral.html
    インモラル:http://www.hikanpou.com/product/immoral.html
    インモラル:http://www.hikanpou.com/product/immoral.html
    妖姫:http://www.hakanpo.com/p/pro481.html
    巨人倍増:http://www.hakanpo.com/p/pro138.html
    威哥王:http://www.hakanpo.com/p/pro96.html
    淫インモラル:http://www.hakanpo.com/p/pro482.html
    花痴:http://www.hikanpou.com/product/花痴.html
    花痴:http://www.hikanpou.com/product/花痴.html
    紅蜘蛛:http://www.hikanpou.com/product/紅蜘蛛.html
    三便宝:http://www.hikanpou.com/product/三便宝.html
    蟻力神:http://www.hikanpou.com/product/蟻力神1.html
    五便宝:http://www.hikanpou.com/product/五便宝.html
    三體牛鞭:http://www.hikanpou.com/product/三体牛鞭.html
    三体牛鞭:http://www.hikanpou.com/product/三体牛鞭.html
    絶對高潮:http://www.hikanpou.com/product/絶對高潮.html
    超級脂肪燃焼弾:http://www.hikanpou.com/product/FAT-BURNERS―3.html
    SUPER FAT BURNING:http://www.hikanpou.com/product/SUPERFATBURNING.html
    終極痩身:http://www.hikanpou.com/product/zhongjishoushen.html
    リドスプレー:http://www.hikanpou.com/product/LIDOSPRAY.html
    D10:http://www.hikanpou.com/product/D10.html
    狼1号:http://www.hikanpou.com/product/狼1号.html
    狼一号:http://www.hikanpou.com/product/狼1号.html
    天天素:http://www.hikanpou.com/product/天天素.html
    中絶薬:http://www.hikanpou.com/pills/避妊中絶.html
    避妊薬:http://www.hikanpou.com/pills/避妊中絶.html
    九鞭粒:http://www.hikanpou.com/product/jiubianli.html
    三鞭粒:http://www.hikanpou.com/product/weige.html
    韓国痩身一号:http://www.hikanpou.com/product/韓国痩身一号.html
    痩身1号:http://www.hikanpou.com/product/韓国痩身一号.html
    D10:http://www.hikanpou.com/product/D10.html
    狼1号:http://www.hikanpou.com/product/狼1号.html
    狼一号:http://www.hikanpou.com/product/狼1号.html
    天天素:http://www.hikanpou.com/product/天天素.html
    中絶薬:http://www.hikanpou.com/pills/避妊中絶.html
    避妊薬:http://www.hikanpou.com/pills/避妊中絶.html
    九鞭粒:http://www.hikanpou.com/product/jiubianli.html
    男宝:http://www.hikanpou.com/product/男宝5箱.html
    壮天根:http://www.hikanpou.com/product/壮天根.html
    夜狼神:http://www.hikanpou.com/product/yelangshen.html
    アフリカ超人:http://www.hikanpou.com/product/chaoren.html
    中華牛鞭:http://www.hikanpou.com/product/中華牛鞭.html
    悦可亭:http://www.hikanpou.com/product/悦可亭.html
    女性用バイアグラ:http://www.hikanpou.com/product/nvweige.html
    FLY D5:http://www.hikanpou.com/product/蒼蝿水5.html
    D5原液:http://www.hikanpou.com/product/蒼蝿水.html
    蒼蝿水:http://www.hikanpou.com/product/蒼蝿水.html
    達克寧(霜剤):http://www.hikanpou.com/product/達克寧.html
    巨人倍増:http://www.hikanpou.com/product/巨人倍増.html
    リドスプレー:http://www.hikanpou.com/product/LIDOSPRAY.html
    レディーチャイナ:http://www.hikanpou.com/product/蒼蝿水5.html
    花之欲:http://www.hikanpou.com/product/花之欲.html
    媚薬:http://www.hikanpou.com/biyaku/女性媚薬.html
    精力剤:http://www.hikanpou.com/seiryokuzai/精力剤.html
    美人豹:http://www.hikanpou.com/product/美人豹.html
    魔根:http://www.hikanpou.com/product/魔根金中草.html
    妻之友:http://www.hikanpou.com/product/妻之友.html
    福源春:http://www.hikanpou.com/product/福源春.html
    早漏防止:http://www.hikanpou.com/seiryokuzai/早漏防止.html
    蟻王:http://www.hikanpou.com/product/アリ王蟻王,ANTKING.html
    アリ王:http://www.hikanpou.com/product/アリ王蟻王,ANTKING.html
    韓国痩身1号:http://www.hikanpou.com/product/韓国痩身一号.html
    痩身一号:http://www.hikanpou.com/product/韓国痩身一号.html
    男露888:http://www.hikanpou.com/product/男露888.html
    蔵八宝:http://www.hikanpou.com/product/蔵八宝.html
    法国性奴:http://www.hikanpou.com/product/fagou.html
    西班牙蒼蝿水:http://www.hikanpou.com/product/魔力蒼蝿水5.html
    性霸2000:http://www.hikanpou.com/product/Xing霸.html
    Xing霸:http://www.hikanpou.com/product/Xing霸.html
    奇果:http://www.hikanpou.com/product/奇果.html
    夜夜堅:http://www.hikanpou.com/product/夜夜堅.html

  • #3

    タオバオ代行 (金曜日, 11 7月 2014 17:16)

    タオバオ代行なら http://jpdaikou.rigouwang.com にお任せ!
    http://jpdaikou.rigouwang.comは業界最安値水準の100円。ただいま送料50%オフキャンペーン実施中。在庫がある商品であれば最短4日で日本までお届けが可能です。難しい中国語不要し、日本語でタオバオを利用できます。
    タオバオ代行:http://jpdaikou.rigouwang.com
    タオバオ:http://jpdaikou.rigouwang.com
    taobao代行:http://jpdaikou.rigouwang.com
    中国のショッピングサイトで買い物をしたいけど、中国語が苦手!日本に送ってくれない!ちゃんと届くか不安!そんな方のご要望にお答えし楽しい海外通販?個人輸入を代行します!当サイトでは、現地日本人スタッフが商品の落札から国際発送まで一括して代行しますので、日本のECサイトと同様の感覚で淘宝をご利用頂けます!
    taobao:http://jpdaikou.rigouwang.com
    中国 代行:http://jpdaikou.rigouwang.com
    中国オークション:http://jpdaikou.rigouwang.com
    淘宝網:http://jpdaikou.rigouwang.com
    http://jpdaikou.rigouwang.com ぜひご利用してください!
    タオバオ代行:http://jpdaikou.rigouwang.com
    タオバオ:http://jpdaikou.rigouwang.com
    タオバオ:http://jpdaikou.rigouwang.com

  • #4

    威哥王 (月曜日, 18 8月 2014 19:00)

    威哥王:http://www.akanpo.net/
    女性媚薬:http://xn--19zl5rhf.akanpo.net/
    紅蜘蛛:http://xn--19zl5rhf.akanpo.net/
    巨人倍増:http://www.xn--gmq15an1qquf7nnhnq.net/
    威哥王:http://www.xn--y5q18fdwfi85apu0a.com/
    五夜神:http://www.xn--dlqq0x36z.com/
    レビトラ:http://www.xn--o9jva1ej2150bft0egnwa.com/
    レビトラ体験談:http://www.xn--o9jva1ej2150bft0egnwa.com/
    精力剤:http://www.xn--t8j4aa4n718noja203w.com/
    精力剤ランキング:http://www.xn--t8j4aa4n718noja203w.com/
    中絶 薬:http://www.akanpo.net/catalog/3.html
    経口避妊薬:http://www.akanpo.net/catalog/3.html
    女性用精力剤:http://www.akanpo.net/catalog/60.html
    媚薬通販:http://www.akanpo.net/catalog/60.html
    催淫剤:http://www.akanpo.net/catalog/63.html
    女性媚薬:http://www.akanpo.net/catalog/60.html
    催淫:http://www.akanpo.net/catalog/63.html
    催情薬:http://www.akanpo.net/catalog/63.html
    漢方薬:http://www.akanpo.net/catalog/2.html
    精力剤:http://www.akanpo.net/catalog/1.html
    徳国黒金:http://www.xn--vcsp6r0y7bp4k.net/
    蔵秘男宝:http://www.xn--pbtr90dtidpyo.com/
    蔵秘男宝:http://www.xn--pbtr90dtidpyo.net/
    イーリーシン:http://www.xn--tfry51gvxj8qe33e.com/
    蟻力神:http://www.xn--tfry51gvxj8qe33e.com/
    中華牛鞭:http://www.xn--fiqx59fy7lwts.net/
    蔵秘雄精:http://www.xn--tmz82dyzk01s.com/
    三体牛鞭:http://www.xn--ehq44ay28e5g5a.net/
    三體牛鞭:http://www.xn--ehq44ay28e5g5a.net/
    勃動力三體牛鞭:http://www.xn--ehq44ay28e5g5a.net/
    男宝:http://www.xn--pbtr90d.net/
    ナンパオ:http://www.xn--pbtr90d.net/
    好漢哥:http://www.xn--kwrt0i78w.com/
    三鞭粒:http://www.xn--ehq774i08q.com/
    威哥王:http://www.xn--ehq774i08q.com/
    五便宝:http://www.xn--dlq51ag0z.com/
    夜夜堅:http://www.xn--fks3ya.com/
    狼一号:http://www.xn--4gq48lvu4a.net/
    狼1号:http://www.xn--4gq48lvu4a.net/
    蟻王:http://www.xn--qbyx94b.com/
    アリ王:http://www.xn--qbyx94b.com/
    壮三天:http://www.xn--ehq78xdf.com/
    魔根:http://www.xn--xxvo15i.com/
    ビグレックス:http://www.xn--pckb2a1b0esh.com/
    VigRx:http://www.xn--pckb2a1b0esh.com/

  • #5

    媚薬 販売 (月曜日, 18 8月 2014 19:03)

    媚薬:http://www.allkanpou.com/
    媚薬 販売:http://www.allkanpou.com/
    花痴:http://www.xn--6qs44kv2wxulv8l.com/
    女性用精力剤:http://www.xn--o0q550b5sivv6a3ud.com/
    女性用媚薬:http://www.xn--o0q550b5sivv6a3ud.com/
    催淫剤:http://www.xn--o0q550b5sivv6a3ud.com/
    中絶薬:http://www.xn--fiqs66igff.net/
    媚薬通販:http://www.allkanpou.com/biyaku/%E5%AA%9A%E8%96%AC.html
    催淫剤:http://www.allkanpou.com/biyaku/%E5%82%AC%E6%B7%AB.html
    女性媚薬:http://www.allkanpou.com/biyaku/%E5%A5%B3%E6%80%A7%E5%AA%9A%E8%96%AC.html
    媚薬激安:http://www.allkanpou.com/biyaku/%E5%A5%B3%E6%80%A7%E5%AA%9A%E8%96%AC.html
    催淫薬:http://www.allkanpou.com/biyaku/%E5%82%AC%E6%B7%AB.html
    興奮剤:http://www.allkanpou.com/biyaku/%E5%82%AC%E6%B7%AB.html
    媚薬カプセル:http://www.allkanpou.com/biyaku/%E5%AA%9A%E8%96%AC%E5%82%AC%E6%B7%AB.html
    催情コーヒー:http://www.allkanpou.com/biyaku/%E5%82%AC%E6%B7%AB.html
    催情薬:http://www.allkanpou.com/product/nvshicuiqing.html
    催情水:http://www.allkanpou.com/product/kkkcao.html
    精力増強剤:http://www.allkanpou.com/seiryokuzai/%E7%B2%BE%E5%8A%9B%E5%A2%97%E5%BC%B7.html
    精力剤:http://www.allkanpou.com/seiryokuzai/%E7%B2%BE%E5%8A%9B%E5%89%A4.html
    中絶薬:http://www.allkanpou.com/pills/%E9%81%BF%E5%A6%8A%E4%B8%AD%E7%B5%B6.html
    漢方薬:http://www.allkanpou.com/kanpouyaku/%E6%BC%A2%E6%96%B9%E8%96%AC.html
    威哥王:http://www.allkanpou.com/product/%E5%A8%81%E5%93%A5%E7%8E%8B.html
    巨人倍増:http://www.allkanpou.com/product/%E5%B7%A8%E4%BA%BA%E5%80%8D%E5%A2%97.html
    紅蜘蛛:http://www.allkanpou.com/product/%E7%B4%85%E8%9C%98%E8%9B%9B.html
    妖姫:http://www.allkanpou.com/product/youhi.html
    淫インモラル:http://www.allkanpou.com/product/immoral.html
    花痴:http://www.allkanpou.com/product/%E8%8A%B1%E7%97%B4.html
    RU486:http://www.allkanpou.com/product/RU486.html
    絶對高潮:http://allkanpou.com/product/%E7%B5%B6%E5%B0%8D%E9%AB%98%E6%BD%AE.html
    蟻王:http://www.allkanpou.com/product/%E3%82%A2%E3%83%AA%E7%8E%8B%E8%9F%BB%E7%8E%8B,ANTKING.html
    蟻力神:http://www.allkanpou.com/product/%E8%9F%BB%E5%8A%9B%E7%A5%9E1.html
    新一粒神:http://www.allkanpou.com/product/%E6%96%B0%E4%B8%80%E7%B2%92%E7%A5%9E.html
    五便宝:http://www.allkanpou.com/product/%E4%BA%94%E4%BE%BF%E5%AE%9D.html
    狼一号:http://www.allkanpou.com/product/%E7%8B%BC1%E5%8F%B7.html
    狼1号:http://www.allkanpou.com/product/%E7%8B%BC1%E5%8F%B7.html
    勃動力三體牛鞭:http://www.allkanpou.com/product/%E4%B8%89%E4%BD%93%E7%89%9B%E9%9E%AD.html
    韓国痩身1号:http://www.allkanpou.com/product/%E9%9F%93%E5%9B%BD%E7%97%A9%E8%BA%AB%E4%B8%801.html
    曲美:http://www.allkanpou.com/product/%E6%9B%B2%E7%BE%8E.html
    消渇丸:http://www.allkanpou.com/product/%E6%B6%88%E6%B8%87%E4%B8%B8.html
    垂盆草:http://www.allkanpou.com/product/%E5%9E%82%E7%9B%86%E8%8D%89.html
    牛黄清心丸:http://www.allkanpou.com/product/%E7%89%9B%E9%BB%84%E6%B8%85%E5%BF%83%E4%B8%B8.html
    雲南白薬:http://www.allkanpou.com/product/%E9%9B%B2%E5%8D%97%E7%99%BD%E8%96%AC.html
    滋養強精:http://www.allkanpou.com/seiryokuzai/%E6%BB%8B%E9%A4%8A%E5%BC%B7%E7%B2%BE.html
    V26:http://www.allkanpou.com/product/verl.html
    天天素:http://www.allkanpou.com/product/%E5%A4%A9%E5%A4%A9%E7%B4%A0.html
    片仔廣:http://www.allkanpou.com/product/%E7%89%87%E4%BB%94%E5%BB%A3.html
    黒倍王:http://www.allkanpou.com/product/%E9%BB%92%E5%80%8D%E7%8E%8B.html

  • #6

    精力剤 (月曜日, 18 8月 2014 19:03)

    ED治療薬:http://www.yahookanpou.com/
    精力剤:http://www.yahookanpou.com/
    威哥王:http://www.xn--kwr27ggxai8kiw5akr5a.net/
    中絶薬:http://www.xn--fiqv0z4mai18ikui.com/
    巨人倍増:http://www.xn--tckuez55h0fbkxjnoie3j.com/
    花痴:http://www.xn--ogry99byokxmm.com/
    シアリス:http://www.xn--cckybh9qw11qzch087f.com/
    レビトラ:http://www.xn--fdkva1ej2834bwg0a.com/
    プロコミルスプレー:http://www.xn--tckm2gc2b7djc5l.com/
    催情:http://www.xn--o0q550b.net/
    催情液:http://www.xn--o0q550bwwj.com/
    女性用媚薬:http://www.xn--o0q550bwwj.com/
    淫インモラル:http://www.xn--o0q550b.net/inmonarl.html
    芳香劑:http://www.xn--rush-k09fk36wor7a.com/
    妊娠中絶薬:http://www.xn--fiqv0z4mai18ikui.com/
    巨人倍増口コミ:http://www.xn--tckuez55h0fbkxjnoie3j.com/
    シアリス販売店:http://www.xn--cckybh9qw11qzch087f.com/
    レビトラ効果:http://www.xn--fdkva1ej2834bwg0a.com/
    淫インモラル:http://immoral.yahookanpou.com
    インモラル:http://immoral.yahookanpou.com
    妖姫:http://xn--vvsqh.yahookanpou.com/
    淫インモラル:http://www.xn--eckwgvai1b8519e.com/
    d10催情剤:http://www.xn--d10-y90eq2f999a.com/
    蒼蝿水:http://www.xn--1rw563cv3bezh3ze.com/
    レディーチャイナ:http://www.xn--1rw563cv3bezh3ze.com/
    D5 原液:http://www.xn--1rw563cv3bezh3ze.com/
    インモラル:http://www.xn--eckwgvai1b.net/
    淫インモラル:http://www.xn--eckwgvai1b8519e.net/
    インモラル:http://www.xn--eckwgvai1b7344ch96c.com/
    d10媚薬:http://www.xn--d10-hl9e441q.com/
    韓国痩身一号:http://www.xn--4gq48lkwcy40cp4z0ql.com/
    韓国痩身1号:http://www.xn--4gq48lkwcy40cp4z0ql.com/
    蒼蝿粉:http://www.xn--i6zw1ov9b.com/
    催情丹:http://www.xn--riq92di5x.com/
    催情剤:http://www.xn--riq92di5x.com/
    縮陰膏:http://www.xn--jj0a42ee7z.com/
    d5原液:http://www.xn--d5-8d6cy20h.com/
    FLY D5:http://www.xn--d5-8d6cy20h.com/
    絶對高潮:http://www.xn--wetw46b3hk0yo36dn8t.com/

    西班牙蒼蝿水:http://www.xn--1rwz4kv8a2x0b9edxvd.com/
    花之欲:http://www.xn--9iq971es9p.net/
    壮天根:http://www.xn--2qs4es67b.com/
    滋養強壮:http://www.xn--2qs4es67b.com/

    勃動力三體牛鞭:http://www.yahookanpou.com/product/santiniubian.html
    韓国痩身一号:http://www.yahookanpou.com/product/hgssyhmtx.html
    韓国痩身1号:http://www.yahookanpou.com/product/hgssyhmtx.html
    D10催情剤:http://www.yahookanpou.com/product/meiyao.html
    蟻力神:http://www.yahookanpou.com/product/yilishen.html

    媚薬 ランキング:http://www.yahookanpou.com/catalog/60.html
    女性用媚薬:http://www.yahookanpou.com/catalog/60.html
    精力剤:http://www.yahookanpou.com/catalog/1.html
    中国精力剤:http://www.yahookanpou.com/catalog/1.html
    漢方薬:http://www.yahookanpou.com/catalog/2.html
    漢方販売:http://www.yahookanpou.com/catalog/2.html
    中絶薬:http://www.yahookanpou.com/catalog/3.html
    中絶薬通販:http://www.yahookanpou.com/catalog/3.html
    ダイエット薬:http://www.yahookanpou.com/catalog/4.html
    威哥王:http://www.yahookanpou.com/product/weigwang.html
    巨人倍増:http://www.yahookanpou.com/product/jurenbeizenggouqi.html
    三便宝:http://www.yahookanpou.com/product/sanbianbao.html
    花痴:http://www.yahookanpou.com/product/huachi.html
    紅蜘蛛:http://www.yahookanpou.com/product/hzhzyd.html
    VigRx:http://www.yahookanpou.com/product/vigrx.html
    媚薬:http://www.yahookanpou.com/catalog/61.html
    淫インモラル:http://www.yahookanpou.com/product/tuoku.html
    D5原液:http://www.yahookanpou.com/product/cys.html
    妖姫:http://www.yahookanpou.com/product/youhi.html
    RU486:http://www.yahookanpou.com/product/zjyrubjzz.html