Blogtrottr
Changes are afoot at Blogtrottr!
By popular request, we're bringing in paid plans with some cool new features (and more on the way). You can read all about it in our blog post.
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
請問EXCEL VBA 專家[拖拉]某儲存格採變數方式~
Jul 8th 2013, 23:38

以A欄為例，我是用錄製的~

Range("A2").Select

Selection.AutoFill Destination:=Range("A2:A20"), Type:=xlFillDefault

Range("A2:A20").Select

Calculate

Range("A2").Select

我的需求是~

[1].不要只限定在A欄~希望用浮動式的方式來寫~

比如A欄或B欄或C欄~

也就是執行該程式時~會跑出視窗來問我~要拖拉哪一欄~讓程式變的很靈活~

[2]. Destination:=Range("A2:A20"),

這裡的A20 請改成以變數[最後一列]的方式來處理~

比如 Destination:=Range("A2:A"& 變數),

謝謝~

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html
You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 jmuko99 的頭像
    jmuko99

    2016韓劇推薦好看的 , 學校2015 韓劇 線上看 , 2015韓劇排行榜前十名2016韓劇排行榜前十名 , 好看的韓劇推薦 , 2016韓劇收視率 , 韓劇推薦 , 2017好看的韓劇推薦 ,

    jmuko99 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄