這裏顯示二個版本的差異處。
excel-vba [2009/03/12 13:55] bestlong |
excel-vba [2010/08/23 15:30] (目前版本) |
||
---|---|---|---|
行 84: | 行 84: | ||
Range("A4").Value = "11:22:33" '時間 | Range("A4").Value = "11:22:33" '時間 | ||
Range("A5").Value = "01234" '文字 | Range("A5").Value = "01234" '文字 | ||
+ | End Sub | ||
+ | </code> | ||
+ | === 取得 / 設定 儲存格的計算式 === | ||
+ | == 設定計算式 == | ||
+ | <code> | ||
+ | Sub FormulaRange1() | ||
+ | Range("A10").Formula = "=SUM(A1:A9)" | ||
+ | Range("B10").Formula = "=AVERAGE(B1:B9)" | ||
+ | Range("C10").Formula = "=MAX(C1:C9)" | ||
+ | Range("D10").Formula = "=MIN(D1:D9)" | ||
+ | End Sub | ||
+ | </code> | ||
+ | == 絕對參照 / 相對參照 == | ||
+ | <code> | ||
+ | Sub FormulaRange1() | ||
+ | Range("A3").Formula = "=$A$1+$A$2" '絕對參照 | ||
+ | Range("B3").Formula = "=B1+B2" '相對參照 | ||
End Sub | End Sub | ||
</code> | </code> | ||
行 98: | 行 115: | ||
===== 網路資源 ===== | ===== 網路資源 ===== | ||
+ | ==== 討論區 ==== | ||
+ | * http://gb.twbts.com/index.php?board=3.0 麻辣家族討論區 Excel 討論版 | ||
+ | * http://www.officefans.net/ OfficeFans.net 菁英俱樂部(簡) | ||
+ | * http://www.excelpx.com/ Excel 菁英 討論區(簡) | ||
+ | * http://www.excelhome.net/ Excel HOME http://club.excelhome.net 討論區 http://blog.excelhome.net Blog | ||
+ | ==== BLOG ==== | ||
+ | * [[http://blog.xuite.net/fvba/vbatips|Excel VBA Tips 志工教學]] | ||
+ | * [[http://blog.xuite.net/crdotlin/excel|Excel VBA Comics]] | ||
+ | * [[http://www.wretch.cc/blog/HUNGCHILIN|HUNGCHILIN的Excel分享空間]] | ||
+ | * [[http://chijanzen.net/wp/|chijanzen 雜貨舖]] | ||
+ | * [[http://cat14051.mysinablog.com|Emily 分享學習 VBA]] | ||
+ | * [[http://hi.baidu.com/officecm|ExcelFans]] | ||
+ | ==== 其他 ==== | ||
* [[http://spreadsheetpage.com|The Spreadsheet Page]] | * [[http://spreadsheetpage.com|The Spreadsheet Page]] | ||
* http://puremis.net/excel | * http://puremis.net/excel | ||
行 110: | 行 140: | ||
* http://www.andypope.info | * http://www.andypope.info | ||
* http://www.dailydoseofexcel.com | * http://www.dailydoseofexcel.com | ||
- | |||
- | * [[http://blog.xuite.net/fvba/vbatips|Excel VBA Tips 志工教學]] | ||
- | * [[http://blog.xuite.net/crdotlin/excel|Excel VBA Comics]] | ||
- | * [[http://www.wretch.cc/blog/HUNGCHILIN|HUNGCHILIN的Excel分享空間]] | ||
- | * [[http://chijanzen.net/wp/|chijanzen 雜貨舖]] | ||
- | * [[http://cat14051.mysinablog.com|Emily 分享學習 VBA]] | ||
- | * [[http://www.excelhome.net|ExcelHOME]] [[http://club.excelhome.net|討論區]] [[http://blog.excelhome.net|Blog]] | ||
- | * [[http://hi.baidu.com/officecm|ExcelFans]] | ||